Hi All
I am very new to VBA so would like to ask you all for your expert advice
I have a file with two worksheets, one worksheet (Log) is a list of all the user inputs
The other worksheet (Template) is formatted how I need it to be copied over for the extra worksheets
So...
In the 'Log' worksheet, cell N1, I have a formula that finds the last populated cell and I need to use this name as the worksheet name when created by the macro, so every time a report is inputted I get a new name for the new worksheet.
The other worksheet (Template) needs copying over exactly how it is, renaming as above from N1 then certain data from the 'Log' sheet needs copying over to the newly created sheet, O2 to H3, P2 to X3, Q2 to H4.
Any help would be appreciated, I have been searching google all morning for inspiration but with no joy
Cheers
Carlos
I am very new to VBA so would like to ask you all for your expert advice
I have a file with two worksheets, one worksheet (Log) is a list of all the user inputs
The other worksheet (Template) is formatted how I need it to be copied over for the extra worksheets
So...
In the 'Log' worksheet, cell N1, I have a formula that finds the last populated cell and I need to use this name as the worksheet name when created by the macro, so every time a report is inputted I get a new name for the new worksheet.
The other worksheet (Template) needs copying over exactly how it is, renaming as above from N1 then certain data from the 'Log' sheet needs copying over to the newly created sheet, O2 to H3, P2 to X3, Q2 to H4.
Any help would be appreciated, I have been searching google all morning for inspiration but with no joy
Cheers
Carlos