Mike Ryan
11-25-2015, 03:27 AM
Hello :hi: and I'm pretty new to VBA so please bear with me : pray2:
I have daily worksheets (mon - fri) in a weekly workbook (1 - 52) for a year. What I want to do is use a single worksheet in a single workbook that I can use as an input model, where once I have finished updating I can, on click of a button, run a macro that will return a message box or userform displaying the last workbook saved and the last worksheet added to that workbook. For Example: Workbook 3 / Worksheet Wed. This lets me know that if I continue, the model worksheet will be copied/saved to an added worksheet named Thu in Workbook 3. Then the model will clear leaving a message box stating Week 3, Thursday has been saved. Please let me know if I'm barking up the wrong tree. :think:
I have daily worksheets (mon - fri) in a weekly workbook (1 - 52) for a year. What I want to do is use a single worksheet in a single workbook that I can use as an input model, where once I have finished updating I can, on click of a button, run a macro that will return a message box or userform displaying the last workbook saved and the last worksheet added to that workbook. For Example: Workbook 3 / Worksheet Wed. This lets me know that if I continue, the model worksheet will be copied/saved to an added worksheet named Thu in Workbook 3. Then the model will clear leaving a message box stating Week 3, Thursday has been saved. Please let me know if I'm barking up the wrong tree. :think: