Simple? View named range from sheet1 on sheet2

S

susiew32

I have a sheet with rows of data. I have named ranges for different rows and
columns within that sheet.

How can I view the each named range on a second (summary) sheet? The data
may change, but the size of the named range stays the same, so I know how
many rows I'll be displaying.

Thanks in advance.
 
P

Pete_UK

Suppose you have a range called Seconds on the first sheet, in the
second sheet just type:

=Seconds

in a cell and copy it down as far as you need.

Hope this helps.

Pete
 

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

Need Help with a VBA subroutine 0
Setting a range in a named range 3
How do I have a cell value define a dynamic named range? 15
Compare identifier columns from 2 sheets - remove rows that are dups 2
Referencing a named range on another sheet 4
a data validation list that contains a list of named ranges - not alist from a named range 1
Removing items on Sheet1 that are common to Sheet2 1
How do I only pull rows if the data matches a named range? 0

Top