Most valuable professional
  • Hot Topics

Excel help requested on VBA for combining data over multiple sheets

Hello, I have a large number of sheets in my workbook that i would like to combine into one sheet. Every sheet has a similar setup and has 2 rows: the first has the coloumn headers in it the second has a number of values the first column contains a unique article number What i would like to do is have a script that adds all these rows below each other on one sheet. The values should however be filled in under the corresponding header... You can find an example excell with the tabs i would like to combine here: In the tab result you can see what i'm trying to accomplish (mockup). I really hope someone could help me with this!!! For those that don't like to download stuff below a small sample... Sheet 1 ID 654362168 Sheet 2 ID

This question generated 17 answers. To proceed to the answers, click here.

This thread is current as of February 5, 2015.

For more resources for Microsoft Excel:

This article includes the following tags:

  • Excel
  • Microsoft Excel