It doesn't work off of just the headers, you specify the whole row and column, like
=A2:C2 B1:B10
or
=2:2 B:B
It doesn't work off of just the headers, you specify the whole row and column, like
=A2:C2 B1:B10
or
=2:2 B:B
Okay, so that doesn't appear to be my problem after all. I'm not sure how to design this...
We want a workbook where each user has their own worksheet.
The admin creates a specific workout regimen, such as 15 pushups, situps and squats.
That's for medium intensity. There is also Light and Heavy intensities.
Then, there is up to 100 different exercises.
He wants to, for instance, create a week's worth of cycles in advance. The user opens the workbook and chooses their intensity, and it's populated for the cycle for that day that he created. I can't work it out how I'm gonna get:
Name
Intensity
Exercise
Reps
Any suggests?
Anne: If you post a sample spreadsheet with some examples of what you want to achieve, then I'm sure someone can help you out.
Okay, I posted, but the file was incomplete. I'll fix it up and upload. Thanks!
Was it deleted again? I dont' see it now.. ?
Regards,
Zack Barresse
Something like this? Range retrieval.xlsx
Or do you want the user to be able to select a different intensity each day?
This sounds like it should be in Access...![]()
Regards,
Zack Barresse
LOL That's what I told him. The thing is, he doesn't even have Excel. He originally wanted Googledocs (again), but it barely doesn't a data validation.
Thanks, guys. Sorry. I'm suggesting a web-based app with MySQL, which I may actually learn.
And I heard you laugh just then, Zack.![]()
Bookmarks