I have user data in User_Columns. The user will paste this data in. It can have any number of rows or columns.
The second tab will be Needed_Columns - which is where the chosen columns will be pasted.
The second tab is now populated with what the end result should be.
I would like a message box to ask the user to identify each column of the User_Data.
Something like "What column is your 'Zone' located?", "What column is your 'Service' located?, etc.
(The columns are on Needed_Columns tab)
There are 14 columns needed.
Then the VBA would choose those columns, paste into the Needed_Columns tab and change the header names from the users to mine.
Can anyone help? Thanks!