Ok. So hopefully someone has a solution to this one. Please see my excel file for more information.
I have a list that I input. Laps, Sit Ups, Jumps, Push Up, Stretch….. I tell my list how many minutes I want to work out in Total and what percentage of time I want to spend on each exercise in that time. It is easy to have Excel calculate how many minutes I spend on each exercise. It is the next step that I need help with.
Once I create this table with the entries, I want to create two columns from the information. I want the first Column to autofill in whole number increments the total number of minutes to work out. I want the second column to autofill each cell with the corresponding Exercise. So if I enter 20 minutes, there should be 1, 2, 3, …..20 minutes. If I enter 15% of time is Laps, then 3 cells should show Laps. 25% Sit Ups, then 5 cells of Sit Ups. Right now I am manually entering the column but I want it to autofill and I don’t know how to go about doing this.
I also want the two autofilled columns to update when I change the original list (total # of Minutes, or % of time)
My original problem is a much longer list (and not exercise based), but I’ve simplified for this example.
Any help appreciated.
I have a list that I input. Laps, Sit Ups, Jumps, Push Up, Stretch….. I tell my list how many minutes I want to work out in Total and what percentage of time I want to spend on each exercise in that time. It is easy to have Excel calculate how many minutes I spend on each exercise. It is the next step that I need help with.
Once I create this table with the entries, I want to create two columns from the information. I want the first Column to autofill in whole number increments the total number of minutes to work out. I want the second column to autofill each cell with the corresponding Exercise. So if I enter 20 minutes, there should be 1, 2, 3, …..20 minutes. If I enter 15% of time is Laps, then 3 cells should show Laps. 25% Sit Ups, then 5 cells of Sit Ups. Right now I am manually entering the column but I want it to autofill and I don’t know how to go about doing this.
I also want the two autofilled columns to update when I change the original list (total # of Minutes, or % of time)
My original problem is a much longer list (and not exercise based), but I’ve simplified for this example.
Any help appreciated.
