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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

setting one worksheet cell range reference to another worksheet 1
Excel Limit to Named Ranges 1
Copy range from one open workbook's worksheet to another. 4
Scattered array cells copy to scattered array cells another workbook 14
Copy Multiple Areas from One Workbook to Another 4
Method to automate page numbers on single worksheet 1
Macro to print specified range of several work sheets 2
copying cells from one worksheet to another 1

Back
Top