Display ranges from one worksheet to another

  • Thread starter Thread starter Opal
  • Start date Start date
O

Opal

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......
 
Back
Top