Display ranges from one worksheet to another
 

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.

Display ranges from one worksheet to another
 

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

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



"Opal" wrote in message
...
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.

Display ranges from one worksheet to another
 

Hmmm...

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