Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
named range and link
Normally I know how to paste a link to a spredsheet into a cell in another
spreadsheet - however I want to not only paste a link but I need to have the formula pick - not from an entire row but from a named range - was hoping to use this formula but just don't know to change it OFFSET(Sheet1!$A$1,MATCH(MAX(Sheet1!$A:$A),Sheet1! $A:$A)-1,COLUMN()-1) |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
named range and link
Forgot to mention that the goal is to copy an entire row from one spreadsheet
to another based on data in column A so I would take the formula and drag it empty cells in the new spreadsheet to pick up the data from the other "na" wrote: Normally I know how to paste a link to a spredsheet into a cell in another spreadsheet - however I want to not only paste a link but I need to have the formula pick - not from an entire row but from a named range - was hoping to use this formula but just don't know to change it OFFSET(Sheet1!$A$1,MATCH(MAX(Sheet1!$A:$A),Sheet1! $A:$A)-1,COLUMN()-1) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Print Named Cells highlights web link to Excel range | Excel Discussion (Misc queries) | |||
Excel2000:How to link Print Area with a named range | Excel Discussion (Misc queries) | |||
Excel2000:How to link Print Area with a named range | Excel Worksheet Functions | |||
Link to a named range in another worksheet that is sorted frequent | Excel Worksheet Functions | |||
External link to Named Range | Excel Discussion (Misc queries) |