I am in charge of reviewing changes in our company's shipping schedule, and I will frequently get updated information that has maybe 100 columns and any number of rows. I never know what the column headers are going to be. Currently, I have to copy all of the volume information by hand into another worksheet, which is rather tedious. I am trying to make a program that will do all of this for me, and I'm stuck on this one point.
I have made a userform (UserForm1) that allows me to pick the range of data using a RefEdit control. Ideally, I would like to use the userform to pick only the column headers and have my program copy all of the data (minus the column header) in those columns into my other worksheet.
If I have in my RefEdit control a cell reference of 'Sheet1'!$R$2:$Z$2, how can I reference just the column information so that I can copy all of my data?
Thanks in advance
I have made a userform (UserForm1) that allows me to pick the range of data using a RefEdit control. Ideally, I would like to use the userform to pick only the column headers and have my program copy all of the data (minus the column header) in those columns into my other worksheet.
If I have in my RefEdit control a cell reference of 'Sheet1'!$R$2:$Z$2, how can I reference just the column information so that I can copy all of my data?
Thanks in advance