Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Reference sheets
I am setting up a spreadsheet that I need help with. In the first column, I
want them to choose their name from a list of about 80 names. In the 2nd column, I want them to choose their role from a list of 6 roles. In the next 3 columns, I want them to choose their mentors, but the list of choices is determinant on what they chose for their role in the 2nd column. Can anyone please help with how to set this entire spreadsheet up? Thank You! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Reference sheets
http://www.contextures.com/xlDataVal02.html
try debra tip's. hth -- regards from Brazil Thanks in advance for your feedback. Marcelo "KKcags" escreveu: I am setting up a spreadsheet that I need help with. In the first column, I want them to choose their name from a list of about 80 names. In the 2nd column, I want them to choose their role from a list of 6 roles. In the next 3 columns, I want them to choose their mentors, but the list of choices is determinant on what they chose for their role in the 2nd column. Can anyone please help with how to set this entire spreadsheet up? Thank You! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
formula reference~muliple sheets | Excel Discussion (Misc queries) | |||
Cross Reference between sheets | Excel Worksheet Functions | |||
How to have a variable cell reference across sheets? | Excel Discussion (Misc queries) | |||
Cell Reference, Multiple Sheets | Excel Worksheet Functions | |||
in VBA Sheets("mysheet").Copy Befo=Sheets(1) how do i get a reference to the newly created copy of this sheet? | Excel Worksheet Functions |