Ok so I have a worksheet that I use as tracking sheet for a specific workout program. Each workout program as multiple tracking sheets. So in order to not have hundreds of sheets. I combined the tracking sheets for a specific program onto one sheet with a drop down box that controls the visibility of the various tracking sheets. Workout 1 has range of 9 to 50, Workout 2 has range of 52 to 100, Workout 3 has range of 102 to 150
I want to add a button (I know how to add the button) with a macro that will add another day to the tracking sheet. This would mean copying just the formatting and formulas from the day above and inserting it in below it. By doing this, this would change the range of Workout 1 to 9 to 54 so that macro would need to update every time a day gets added to the tracking sheets.
I would like all of this to work dynamically and constantly be up to date and have the user be able to add as many workout days to their log.
Bookmarks