Hey guys-
I spent most the night searching, and attempting this- but not finding an easy solution. I have 60+ worksheets, all have about 30+ columns in them. The column order and headers are not the same (similar, but not the same). I need to take about 8 of the columns from each, and combine/append all that data into one sheet. So, the "First Name" column from each sheet will append to the Master Sheet- giving me a master sheet with 8 columns total and all the data from the source sheets appended within that. I hope that makes sense.
So, I know I can manually copy/paste it one by one. I did that before with only 3 columns, and it took me over a day to complete. Now I need 8+ columns and I want to find an easier way.
I know I can setup a Connection/Microsoft Query. But, since the headers/column orders don't match up, I would need a way to map each sheet's columns to the master sheet's columns.
Question: Is there a way to import sheets, and map the columns from each sheet to the master sheet's columns? It would then need to append that data to the existing data in the master sheet's columns. I was hoping there was an easy drag/drop type interface to do this (even within Access maybe???) and not a VBA solution (not good at all with VBA, I think it'll cause more problems as the data isn't consistent).
Sidenote- not sure if it matters, but- some of the rows might have blanks/empty cells.
Thanks for all the help guys!!!
I spent most the night searching, and attempting this- but not finding an easy solution. I have 60+ worksheets, all have about 30+ columns in them. The column order and headers are not the same (similar, but not the same). I need to take about 8 of the columns from each, and combine/append all that data into one sheet. So, the "First Name" column from each sheet will append to the Master Sheet- giving me a master sheet with 8 columns total and all the data from the source sheets appended within that. I hope that makes sense.
So, I know I can manually copy/paste it one by one. I did that before with only 3 columns, and it took me over a day to complete. Now I need 8+ columns and I want to find an easier way.
I know I can setup a Connection/Microsoft Query. But, since the headers/column orders don't match up, I would need a way to map each sheet's columns to the master sheet's columns.
Question: Is there a way to import sheets, and map the columns from each sheet to the master sheet's columns? It would then need to append that data to the existing data in the master sheet's columns. I was hoping there was an easy drag/drop type interface to do this (even within Access maybe???) and not a VBA solution (not good at all with VBA, I think it'll cause more problems as the data isn't consistent).
Sidenote- not sure if it matters, but- some of the rows might have blanks/empty cells.
Thanks for all the help guys!!!