Hi,
Sorry about title, hard to explain in a few words...
I have a sheet with multiple tabs, Squat (1), Bench (1), Deadlift (1), Squat (2) etc. I would like to put the value from B8 and B5 from each of those sheets (and new ones that have not yet been created).
This can be done manually, but will end up being quite tedious to create each time a new sheet is added. Currently I have this formula ("Squat" is replace with "Bench" and "Deadlift" depending the cell)
Now when I copy downward that is when it breaks as I keep getting the "row" increasing in number but it out paces the sheet numbers.Please Login or Register to view this content.
Attached is the workbook.Daily Workout.xlsx
Thanks
Bookmarks