PLEASE HELP!!! How do I track data without formulas?

Hello. I have created an advanced Excel Workbook for tracking client's workouts. I can input exercises and the data, such as the weights you lifted and the reps you did. HERE'S THE PROBLEM WITH IT. There are 7 KEY EXERCISES that need to be track-able. I can not use formulas to track data for those 7 key exercises because formulas need to be attached to specific cells (such as cell A1). But I don't know which cells those 7 key exercises will appear in, because it constantly changes. It might be cell A8 and the next day it might be cell A20. So instead of attaching formulas like MAX FORMULA or AVERAGE FORMULA to specific cells, I need to attach those formulas to the exercise names themselves. That way, the formulas will follow those 7 key exercises no matter which cell they end up in. To do this, I probably need to make those 7 key exercises into MACROS and then attach the formulas to the MACROS. Correct? Or how can I do this?

This is what the Workbook looks like...

Workouts 1 (what the sheet looks like).jpg


The 7 key exercises can appear anywhere in any cell...

Workouts 2 (exercises can appear in any row).jpg


These are the 7 key exercises...

Workouts 3 (which exercises are trackable).jpg


And the data from those 7 key exercises gets pulled into the "Weekly Results Sheet" here...

Workouts 5 (how weekly results works).jpg


THANK YOU EVERYONE FOR ALL YOUR HELP AND ADVICE!!!

Originally Posted by Mumps1

It is hard to work with pictures. I can't promise a solution but it would be easier to help and test possible solutions if you could attach a copy of your file. Explain in detail what you want to do referring to specific cells, rows, columns and sheets using a few examples from your data (de-sensitized if necessary). Explain in detail what you mean by "tracking". See the yellow banner at the top of this page for instructions to attach a file.

Hello, thank you so much for responding!!!
I will attach a copy of the Workbook once I get home. I can upload it to Google Drive or DropBox and send you the link to it too. I'll explain what I'm trying to do. If you wanted to grab the highest number from a certain row, and let's just say that row is A1 to Z1. Then you would normally just use the MAX Formula. You would type in =MAX(A1:Z1). And the MAX Formula will automatically grab the highest number from that row and drop it wherever you want. That is simple and easy. But here is my problem:

I can't use formulas to grab data for the 7 key exercises that I need to track. Because formulas must be attached to cells, rows, or columns. But I don't know which cells, rows, or columns those 7 key exercises will end up appearing in. FOR EXAMPLE: The exercise SQUATS might appear in cell A4. Or it might be cell A13. Or A22 or A34. So if I wanted to grab the HIGHEST NUMBER OF REPS executed for squats, then I don't know which row to put that MAX Formula into beforehand. Because it might be row 4, row 13, row 22, row 34, etc.

Do you understand a little better now? I'm trying to pre-program this Workbook with formulas to grab specific data, like the highest number of reps executed for Squats or the lowest rest time you took during Deadlifts. But since I don't know which cells or rows those exercises will end up appearing in, I can't pre-program the Formulas into any specific row. ANOTHER EXAMPLE: If I pre-program ROW 4 with the formulas I am using for BENCH. That exercise might end up appearing in ROW 12. So the formulas for BENCH in ROW 4 were completely useless, because BENCH never appeared in ROW 4. It actually appeared in ROW 12. So if I'm going to pre-program the Workbook with these formulas, then I need to attach the formulas to the names of the exercises themselves. That way, the formula will stay with the exercise no matter which row it appears in.

SOMEONE ELSE MENTIONED that I could use something like a MATCH formula or FIND formula to do this task. And combine it with a MAX formula. That way, the exercise can be automatically located no matter which row it ends up appearing in. And then the MAX formula will grab the data from it. I'm just saying that was their idea for solving this.

BEST REGARDS!!!!!

Originally Posted by Mumps1

Thank you for the detailed explanation. I will wait for the link to your file.

HERE IT IS. AS I PROMISED YOU. I uploaded the document to Google Drive. You can edit the document with this link. I think I uploaded the link or document correctly. It's very confusing about how to do it on here. I can't just copy and paste the link to Google Drive. I had to go to "GO ADVANCED" and then "MANAGE ATTACHMENTS" and then upload it.