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 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
<tbody>
</tbody>
Sheet 2
<tbody>
</tbody>
Combination - result
<tbody>
</tbody>
Thanks,
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 |
<tbody>
</tbody>
Sheet 2
ID | attribute X | attribute 4 | attribute 1 | attribute Y |
1255 | value X | 123 | value 2 | Value Y |
<tbody>
</tbody>
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 |
<tbody>
</tbody>
Thanks,