Dropdown menu

[nadia.younus]

Hi,

I'm creating an Excel workbook with three worksheets. I have been
successful in pulling data from Sheet 2 into Sheet 1 using VLOOKUPs
and cell ranges (where BroadBand is a named range of cells):

=VLOOKUP(A6,BroadBand,5,FALSE)

My columns in Sheet A are headed with dates, showing only the past 4
weeks.

I have created a dropdown list which allows me to select a specific
week number e.g. week 1, 2, 3 etc. What I want is when I select week
8, I only want weeks 5, 6, 7, and 8 displaying and automatically
hiding any other weeks (1,2,3,4,9,10,11,12 etc). Likewise, if I want
to see week 4, then I only want weeks 1, 2, 3, and 4 displaying. Is
there any way I can do this in Excel? If so, please explain very
clearly. If this requires any VB coding, please could you kindly
supply me with example code?

Thank you!

Nadia

 

[jlclyde]

Hi,

I'm creating an Excel workbook with three worksheets. I have been
successful in pulling data from Sheet 2 into Sheet 1 using VLOOKUPs
and cell ranges (where BroadBand is a named range of cells):

=VLOOKUP(A6,BroadBand,5,FALSE)

My columns in Sheet A are headed with dates, showing only the past 4
weeks.

I have created a dropdown list which allows me to select a specific
week number e.g. week 1, 2, 3 etc. What I want is when I select week
8, I only want weeks 5, 6, 7, and 8 displaying and automatically
hiding any other weeks (1,2,3,4,9,10,11,12 etc). Likewise, if I want
to see week 4, then I only want weeks 1, 2, 3, and 4 displaying. Is
there any way I can do this in Excel? If so, please explain very
clearly. If this requires any VB coding, please could you kindly
supply me with example code?

Thank you!

Nadia

Coudl you supply a sample fo what your data looks like?
Why not just use lookup again to get the information from the four
week time span you are looking at?
Jay

 

[nadia.younus]

Sorry, I forgot to say, the idea is that I only want up to 4 weeks to
be displayed which is why I need either a method via Excel or some
coding help in Excel macros.

 

[nadia.younus]

I have emailed you a sample file - please see if you can understand
what I am trying to do.

Thanks.