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 |
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 |
All times are GMT +1. The time now is 12:16 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com