Create a new sheet based on a cell value
Hello,
I have a spreadsheet containing over 400 rows of data and 7 columns. The number of rows change from each week. I need to create a macro that can create a new sheet for each row. Also, on the new sheets data would begin on row 13, and new sheet would be named whatever the ID number is. See below for example.
Example sheet 1
ID Name Nickname Position Department Sub-department Q1 2015 Score
210033 James Franco Jimmy Cost Supervisor Finance Accounting 97
214044 Bill Gates Billy Income Auditor Finance Accounting 67
So the new sheet would be:
Example sheet2 named 210033
ID Name Nickname Position Department Sub-department Q1 2015 Score
210033 James Franco Jimmy Cost Supervisor Finance Accounting 97
Example sheet3 named 214044
ID Name Nickname Position Department Sub-department Q1 2015 Score
214044 Bill Gates Billy Income Auditor Finance Accounting 67
Can anyone help me with this?
Thank you!
Recent comments
5 years 50 weeks ago
6 years 36 weeks ago
6 years 47 weeks ago
6 years 50 weeks ago
6 years 51 weeks ago
7 years 5 weeks ago
7 years 13 weeks ago
7 years 13 weeks ago
7 years 13 weeks ago
7 years 13 weeks ago