Excel: Create Sheets And Copy data To Each Sheet


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

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
[CENTER]Sheet1[/CENTER] 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
[CENTER]1[/CENTER] Excel 2010
A B C
1 Part Description
2 J4825024 Test 1 2
3 J4965013 Test 2 0
4 J4828004 Test 3 2
[CENTER]2[/CENTER] Thanks, any further clarification please let me know.


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

This thread is current as of July 14, 2014.


For more resources for Microsoft Excel