Good morning,
At the top of all of my worksheets is a table that calculates a lifter's 1 rep max and 5 rep max (G1:L5) based on changes made in the yellow cells. This table is the same on every worksheet. I would like it so that no matter what sheet I'm on, when a change is made in a yellow cell, the same change is also made on the same tables in the all other worksheets. I would like all the tables to mirror each other. As it is right now, if you make a change on one table, you have to manually make the same changes on all the tables in the other worksheets.
So, instead of having 5 separate tables (one separate table on each of the 5 worksheets), have one single table that is mirrored across all 5 worksheets so that you only have to manipulate the table once to see the change across all the worksheets.
I understand I could just have the tables in worksheets 2-5 mirror what's on the table in worksheet 1, but I dont want to have to switch to the 1st worksheet to make a change. I hope this make sense, lol.
Bookmarks