Dazzawm
Well-known Member
- Joined
- Jan 24, 2011
- Messages
- 3,748
- Office Version
- 365
- Platform
- Windows
I have sheet 1 as laid out below I need a macro that will create sheets and name them the headings that is in row 1 starting in column C and copy their respective data. The amount of columns may vary on every file I use the code on.
Excel 2010
<tbody>
</tbody>
This is how it would look with just a couple of the sheets as an example.
Excel 2010
<tbody>
</tbody>
Excel 2010
<tbody>
</tbody>
Thanks, any further clarification please let me know.
Excel 2010
A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | Part | Description | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | TOTAL |
2 | J4825024 | Test 1 | 1 | 2 | 0 | 2 | 2 | 2 | 0 | 2 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 13 |
3 | J4965013 | Test 2 | 2 | 0 | 0 | 1 | 2 | 2 | 2 | 2 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 13 |
4 | J4828004 | Test 3 | 0 | 2 | 0 | 1 | 2 | 2 | 1 | 2 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 11 |
<tbody>
</tbody>
Sheet1
This is how it would look with just a couple of the sheets as an example.
Excel 2010
A | B | C | |
---|---|---|---|
1 | Part | Description | |
2 | J4825024 | Test 1 | 1 |
3 | J4965013 | Test 2 | 2 |
4 | J4828004 | Test 3 | 0 |
<tbody>
</tbody>
1
Excel 2010
A | B | C | |
---|---|---|---|
1 | Part | Description | |
2 | J4825024 | Test 1 | 2 |
3 | J4965013 | Test 2 | 0 |
4 | J4828004 | Test 3 | 2 |
<tbody>
</tbody>
2
Thanks, any further clarification please let me know.
Last edited: