I have a table of workstreams that on the go. There is a main page with all the workstreams on at the moment, and then sheets name depending on the reference for ease of tracking. So 'Home', 'ABC001', "ABC002' etc.
Could I create a macro that would make a new row and record the next available reference number, copy a template sheet, and change the sheet name based upon what the new reference would be?
Could I create a macro that would make a new row and record the next available reference number, copy a template sheet, and change the sheet name based upon what the new reference would be?
| Reference | Heading | Date |
| ABC001 | Test1 | 1/5/22 |
| ABC002 | Test99 | 1/6/22 |
| ABC003 | TestWhoCares | TBC |
