hello all i am a beginner self taught and trying to learn vba, macro, and excel functions
i have a problem.
i would like to add a sheet to my workbook. once i add the worksheet to the book i want to name it and then have the name of the worksheet that i just created auto populate on a "master" sheet with all the names that i have added to the workbook. i already have the macro to add the new sheet and prompt to name it and works fine. i just cant figure out how to have it automatically add the name to the "master" sheet.
i.e. i have a workbook that goes by months; jan, feb, mar. i have jan, feb, mar on my mater sheet already. i want to add apr later on and have apr appear on the master sheet after i create the apr sheet. i know it would be easy to just have all the months in already but this is just an example.
any help or tips would be greatly appreciated.
thank you for your time.
Bookmarks