I am running excel 2003. I have been given the task
of creating a workbook where on one main sheet
I want to display named ranges from up to 4 other
worksheets based on the user selection.

The ranges are work weeks and we want to be
able to display 8 weeks at a time for resource
planning. Can someone point me in a
direction where I can find a way to do this?

Thank you.

Check Ron's site under the Copy/Paste section.

http://www.rondebruin.nl/tips.htm



"Opal" <(E-Mail Removed)> wrote in message
news:eb392038-e6ab-46b0-a3d6-(E-Mail Removed)...
>I am running excel 2003. I have been given the task
> of creating a workbook where on one main sheet
> I want to display named ranges from up to 4 other
> worksheets based on the user selection.
>
> The ranges are work weeks and we want to be
> able to display 8 weeks at a time for resource
> planning. Can someone point me in a
> direction where I can find a way to do this?
>
> Thank you.

Hmmm...

I was also wondering about using OFFSET
in my named ranges and using a scroll bar
to advance by week......