It's a long time (15+ years) since I had to do any VBA so I've forgotten whatever I knew (although I probably couldn't have done this back then either!). Looks like macros have been replaced by scripts?
I'm trying to automate a workbook for managing change requests. I have three tabs in a "clean" workbook (there's a workbook for each project).
Tab 1 is for obtaining a change number. I'm creating the change number with a formula which is stored in a hidden row named LOG_BLANK
Tab 2 is a summary sheet which retrieves details from each change sheet. I have formulae to retrieve these details in hidden row named SUMMARY_BLANK
Tab 3 is a template change sheet (this will be hidden)
What I'm trying to do is;
I'm trying to automate a workbook for managing change requests. I have three tabs in a "clean" workbook (there's a workbook for each project).
Tab 1 is for obtaining a change number. I'm creating the change number with a formula which is stored in a hidden row named LOG_BLANK
Tab 2 is a summary sheet which retrieves details from each change sheet. I have formulae to retrieve these details in hidden row named SUMMARY_BLANK
Tab 3 is a template change sheet (this will be hidden)
What I'm trying to do is;
- In the log sheet, insert a row above LOG_BLANK and copy the contents of LOG_BLANK into the new row. This will give a new change number via the copied formula. The change number is in the format nnn-nnn. There are other formulae in this row which is why I need to copy the row rather than just a cell.
- In the summary sheet, insert a row above SUMMARY_BLANK and copy the contents of SUMMARY_BLANK into the new row
- Copy the template change sheet tab to a new tab and rename the tab with the nnn-nnn change number created via the formula in the log sheet