Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Simple? View named range from sheet1 on sheet2
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Simple? View named range from sheet1 on sheet2
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 On Aug 27, 3:08*pm, susiew32 wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Populate growing range of cells from Sheet1 to Sheet2 | New Users to Excel | |||
copy data from sheet2 to sheet1 when sheet2 has variable # of rows | Excel Discussion (Misc queries) | |||
how do copy "sheet1!A1+1 in sheet2 to sheet 3 and get "sheet2!A1+ | Excel Discussion (Misc queries) | |||
[=Sheet1!A1] - if i use Column A1 ('Sheet1') / A2 ('Sheet2') | Excel Worksheet Functions | |||
Referencing sheet1 from sheet2 | Excel Worksheet Functions |