[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 403
  • Last Modified:

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.
0
kris_sk2012
Asked:
kris_sk2012
  • 2
1 Solution
 
netballiCommented:
kindly explain with example what do you mean by

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.
0
 
NorieCommented:
What do you mean by 'tab'?
0
 
kris_sk2012Author Commented:
Attached are the template and raw data files. Please let me know if what I'm looking for is possible.
Template.xlsx
Rawdata.xlsx
0
 
netballiCommented:
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.
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now