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: http://www.sonic-websites.be/blog/wp...t-bosch21.xlsx 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 attribute 1 attribute 2 attribute 3 attribute 4
654362168 value 654 value 545 5
Sheet 2
ID attribute X attribute 4 attribute 1 attribute Y
1255 value X 123 value 2 Value Y
Combination - result
ID attribute 1 attribute 2 attribute 3 attribute 4 attribute X attribute Y
654362168 value 654 value 545 5
1255 value 2 123 value X value Y
Thanks,


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

This thread is current as of February 05, 2015.


For more resources for Microsoft Excel