Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
help with worksheet design
I have a workbook with 2 worksheets...Worksheet 1 'Workout'...Worksheet 2
'Exercises'. Worksheet 1 I have set up to pull data from Worksheet 2 to compete a workout form. The setup of 'Exercises' worksheet is as follows (Category, Chest, Abs) columns as named ranges...see example... Categry Chest Abs Chest Chest Flye Reverse Crunch Abs Bench PRess Basic Crunch In my 'Workout' w.sheet i have a data validation drop down choosing 'category', then a vlookup based on that choice showing the exercises that match the Category in a row. All of this is working fine...however here is my dilema.... I am wanting to have a column for 'Description' in my 'Exercises' worksheet to list the description for the exercises but I can't figure out how to input this data to match this specific exercise. I want this data to be automatically inserted in my 'workout' based on the exercise chosen. P.S. I wanted to add that I have attempted to set up my 'Exercise' worksheet like this... Column 1 = Category (chest, leg, ab) Column 2 = Exercise Column 3 = Description which makes more sense to me in trying to associate the exercise with the description but i could not get the formulas correct on my 'workout' w.sheet to give me a drop down of the categories, then be able to pick just the exercises from that chosen category. It would only match row by row. help! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
help with worksheet design
need to make a correction to my information below...second paragraph...
column 1...i have a data validation with source - 'categories' column 2...then i have a data validation with source - =indirect (a5) that pulls information from the categories list depending on what category is chosen "LTOSH" wrote: I have a workbook with 2 worksheets...Worksheet 1 'Workout'...Worksheet 2 'Exercises'. Worksheet 1 I have set up to pull data from Worksheet 2 to compete a workout form. The setup of 'Exercises' worksheet is as follows (Category, Chest, Abs) columns as named ranges...see example... Categry Chest Abs Chest Chest Flye Reverse Crunch Abs Bench PRess Basic Crunch In my 'Workout' w.sheet i have a data validation drop down choosing 'category', then a vlookup based on that choice showing the exercises that match the Category in a row. All of this is working fine...however here is my dilema.... I am wanting to have a column for 'Description' in my 'Exercises' worksheet to list the description for the exercises but I can't figure out how to input this data to match this specific exercise. I want this data to be automatically inserted in my 'workout' based on the exercise chosen. P.S. I wanted to add that I have attempted to set up my 'Exercise' worksheet like this... Column 1 = Category (chest, leg, ab) Column 2 = Exercise Column 3 = Description which makes more sense to me in trying to associate the exercise with the description but i could not get the formulas correct on my 'workout' w.sheet to give me a drop down of the categories, then be able to pick just the exercises from that chosen category. It would only match row by row. help! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
help with worksheet design
so it your data is in a table and you're uising vlookup to get the excercide,
why don't you use vlookup to get the description? "LTOSH" wrote: I have a workbook with 2 worksheets...Worksheet 1 'Workout'...Worksheet 2 'Exercises'. Worksheet 1 I have set up to pull data from Worksheet 2 to compete a workout form. The setup of 'Exercises' worksheet is as follows (Category, Chest, Abs) columns as named ranges...see example... Categry Chest Abs Chest Chest Flye Reverse Crunch Abs Bench PRess Basic Crunch In my 'Workout' w.sheet i have a data validation drop down choosing 'category', then a vlookup based on that choice showing the exercises that match the Category in a row. All of this is working fine...however here is my dilema.... I am wanting to have a column for 'Description' in my 'Exercises' worksheet to list the description for the exercises but I can't figure out how to input this data to match this specific exercise. I want this data to be automatically inserted in my 'workout' based on the exercise chosen. P.S. I wanted to add that I have attempted to set up my 'Exercise' worksheet like this... Column 1 = Category (chest, leg, ab) Column 2 = Exercise Column 3 = Description which makes more sense to me in trying to associate the exercise with the description but i could not get the formulas correct on my 'workout' w.sheet to give me a drop down of the categories, then be able to pick just the exercises from that chosen category. It would only match row by row. help! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
help with worksheet design | Excel Discussion (Misc queries) | |||
Worksheet DESIGN - Prev. Balance | Excel Programming | |||
Worksheet Design for Automation | Excel Discussion (Misc queries) | |||
Worksheet form design | Excel Discussion (Misc queries) | |||
Hyperlinks Inserted in Design Mode inactive once Exited Design Mod | Excel Programming |