Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
complicated drop down menu question
Hi there,
Perhaps someone can help me with this issue, it's a bit long so bear with me. I have 2 spreadsheets, the first one is called data, the second one is called summary On the data sheet, I have it lay out as a sample like below, in different columns, all in text format week 1 Jan 1 Jan 2 Jan 3 Jan 4 week 2 Jan 8 Jan 9 Jan 10 Jan 11 week 3 Jan 17 Jan 18 Jan 19 On the summary sheet, I'd like to have a drop down menu on cell A1 that should have the week number as my choices, and then as I select the week number, the date will show up on a set of cells and change accordingly as I select a different week on the drop down menu. Thanks for all your help |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
complicated drop down menu question
Assign the range with week 1, week 2, etc.. a name (like WeekNo).
You can then use this name as the Data Validation list source. Simply put =WeekNo in the source box. This allows you to reference a range on another sheet. The just use a VLookup to return your dates =Vlookup(A1,DataSheet!$A$1:$H$52,2,false) (Change the DataSheet to whatever your sheet name is, adjust the range as needed) If your selected week 1 in cell A1 this would return Jan 1 from your sample -- If this helps, please remember to click yes. "Don Doan" wrote: Hi there, Perhaps someone can help me with this issue, it's a bit long so bear with me. I have 2 spreadsheets, the first one is called data, the second one is called summary On the data sheet, I have it lay out as a sample like below, in different columns, all in text format week 1 Jan 1 Jan 2 Jan 3 Jan 4 week 2 Jan 8 Jan 9 Jan 10 Jan 11 week 3 Jan 17 Jan 18 Jan 19 On the summary sheet, I'd like to have a drop down menu on cell A1 that should have the week number as my choices, and then as I select the week number, the date will show up on a set of cells and change accordingly as I select a different week on the drop down menu. Thanks for all your help |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Question on using a Drop Down Menu. | Excel Discussion (Misc queries) | |||
Drop dwn menu. Formula to count selection frm menu in anoth cell? | Excel Worksheet Functions | |||
filter dropdown menu so 2nd drop menu is customized | Excel Worksheet Functions | |||
Complicated question, for me anyway! :) | Excel Worksheet Functions | |||
Cross-referenced drop-down menu (nested drop-downs?) | Excel Worksheet Functions |