Save data for each user

[boivjet]

Hello All,

As I am a somewhat new user to excel I don't know the majority of ways to create what I am producing in my mind. The image I uploaded is of the basic layout of my spreadsheet, I have a data sheet and week1-4 to track the fitness for user over a month. I am wondering if it is possible to be able to store all of the entered information for each person selected in the drop down menu. so say I click on myself, all the numbers for my weekly totals and information entered for each activity would be updated throughout all my sheets.
Any assistance with this would be greatly appreciated.

J

[MarvinP]

Hi boivjet,

Excel works best when the data is arranged in rows and columns. Each row is a different event and each column has a header and contains the same info. It looks like you want a table with the following rows:
Name, DateTime, Activity, duration, points. I think you only need 5 columns to do what you want. Don't leave any blank rows or columns in your data as this hurts Excel. If your data is stored correctly Excel can be a wonderful tool. Watch https://www.youtube.com/watch?v=Du73CPqWGQw and see if it gets you started in the right direction.

[boivjet]

I guess I should explain each activity has a drop down menu as well with 7 different workouts to choose from, depending on the workout selected it will display distance or minutes beside the entry cell which will then calculate points depending on the workout selected. as youtube is blocked from my work I will have to check that out after work but thank you for the video I will be sure to watch it.