Hi Everyone!
I am new here and I have a very basic understanding of macro's so I need lots of help! Thanks in advance
I would like to have a macro created that every time I add a sheet name that contains "Stock_", that sheet name is automatically added to my summary page. Right now, every time I add a sheet with stock details, i have to go to the summary page and manually type in the sheet name so the formulas in the summary page can pick up the relevant information.
I have added a screenshot to show what my summary page looks like:
summary page macro help.jpg
Bookmarks