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