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

Excel Moving data to sheet2 from sheet1 0
VBA - retrieve data on last create named range from previous inserted named range 0
Drop Down with dynamic named range offsheet source list 14
Dependent drop down dynamic range formula, off sheet. 7
Referencing a named range on another sheet 4
Excel VBA to move cells to sheet2 based on selection in sheet1 0
Compare identifier columns from 2 sheets - remove rows that are dups 2
a data validation list that contains a list of named ranges - not alist from a named range 1

Top