Hello,
I am a novice Excel user, but hope to become more experienced over time. I apologize in advance for not knowing the correct terminology to best describe what I am looking for.
I need some help in figuring out how to set up my Excel worksheet for an exercise/workout plan. I will try my best to explain what I need help with by describing how I have set up my exercise plan.
I want to keep track of how many minutes I spend on a cardio machine, how "far" I went, what the level/incline/intensity was, and my heartrates (AVG and MAX) for each day of the week except Sunday (that's my off day to let my body rest).
There are 8 columns on one worksheet (I am using two cardio machines, but for this question/explanation, I am just going to do one as an example). The columns are as follows day of week, date, level, minutes, AVG steps/min, total steps, AVG HR and MAX HR. I skipped Sunday because there will be no info there. Since I want to cut and paste the paper into a small spiral notebook to take with me to the gym, I made four blocks with two weeks per block. That way, I can cut each block to fit the small piece of paper in the notebook. The rows are like this... there are fourteen (14) rows per block and the first two rows of each block are the same. The first two rows contain the name of the machine, the column headers (previously mentioned a couple of sentences ago). The other 12 rows contain the day of the week, date, level, etc., etc., etc. If I want to eliminate a week (because of vacation, illness, or work), I can simply cut the 6 days from the date column and move everything up.
The problem when I move the days up, the first two rows of each block moves up too. How can I make the first two rows of each block stay the same and not move at all while moving the rest of the data in that particular column up (but not the first two rows of each block)?
Does that make sense? Can anyone help me? I'd appreciate any feedback anyone has on this issue.
Thank you very much.
Bookmarks