elsone31
09-17-2015, 05:12 PM
Hi All,
I am using Excel 2007 and 2010.
I need help.
What I would like to happen:
1. Copy the Template to a new sheet in the workbook
2. Have a user input box pop up
3. Input the row number
4. The purpose of the row number is to have the macro cut the data into arrays based on like data(will be numeric and alpha)
Example: Row 1 has 4 different numbers, 109, 1110, 111, 112 so if I put the number 1 in the user box, I would get 4 tabs each one with the data array for each number.
The array for 109 would be E87:P87 and would be copied into the template. I would like the formatting to be retained.
OR if I use Row 2 it would use the names in that row to make the tabs and copy the data array.
5. The data in rows 1- 8 would also need to be copied.
Thanks in advance for any help on this.
E
I am using Excel 2007 and 2010.
I need help.
What I would like to happen:
1. Copy the Template to a new sheet in the workbook
2. Have a user input box pop up
3. Input the row number
4. The purpose of the row number is to have the macro cut the data into arrays based on like data(will be numeric and alpha)
Example: Row 1 has 4 different numbers, 109, 1110, 111, 112 so if I put the number 1 in the user box, I would get 4 tabs each one with the data array for each number.
The array for 109 would be E87:P87 and would be copied into the template. I would like the formatting to be retained.
OR if I use Row 2 it would use the names in that row to make the tabs and copy the data array.
5. The data in rows 1- 8 would also need to be copied.
Thanks in advance for any help on this.
E