Excel copy data from one sheet to another
I have a raw data sheet with 7 tabs. And I need to insert data from this raw sheet to a template sheet with 2 tabsl.
1. Copy first tab from raw to template ( all columns)
2. Copy second tab from raw to template's first tab as a continuation of the first set of columns only if columns A, C, D, E are exactly the same.
I would like to automate this as a macro in future.
1. Copy first tab from raw to template ( all columns)
2. Copy second tab from raw to template's first tab as a continuation of the first set of columns only if columns A, C, D, E are exactly the same.
I would like to automate this as a macro in future.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
What do you mean by 'tab'?
ASKER
Attached are the template and raw data files. Please let me know if what I'm looking for is possible.
Template.xlsx
Rawdata.xlsx
Template.xlsx
Rawdata.xlsx
Sorry for replying late but the number of check you would have to do in getting this data is not very simple.
Even if you get around the limitation on excel formula length you would still have to work with many assumptions which is not a good solution.
I would advice you to look at alternative vb-scripts which can manipulate data from excel sheet and then put in the template worksheet.
Even if you get around the limitation on excel formula length you would still have to work with many assumptions which is not a good solution.
I would advice you to look at alternative vb-scripts which can manipulate data from excel sheet and then put in the template worksheet.