Prev: change multiple links at once
Next: Sorting
From: Don Doan on 8 Apr 2010 12:21
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
From: Paul C on 8 Apr 2010 12:41
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
 | 
Pages: 1
Prev: change multiple links at once
Next: Sorting