How to copy a cell range based on an individual cell

do you mean something like this?

Hi,

Difficult to comment without seeing the workbook, but if I understand the requirement you'd be better off adding an adding an additional column that contains the week reference, preferably a date I suggest since you can then perform date arithmetic should that be necessary. Once you have this additional column then it's a trivial task to filter it.

Naming ranges is good practice, don't get me wrong, but on this occasion I don't believe they bring anything to the party. You could use them I suspect in a macro which identified the range name in question and hid all the other ranges, but that's I suggest a more convoluted way.

The other option would be to use the Custom Views functionality whereby you manually filter what you want to see for each week and add it as a custom view name. But you'd still need a macro to detect the view and then set it.

Hi Merlin and welcome to the forum.

It sounds like you want the following. Change the value in cell A1 to the week number you want to view and see what happens. The code looks like:

Please Login or Register  to view this content.