Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
named range 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 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 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 link
On Sep 17, 8:48 am, 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 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 OFFSET(Sheet1!$A$1,MATCH(MAX(Sheet1!$A:$A),Sheet1! $A:$A)-1,COLUMN()-1) I'm not positive I understand exactly what you want. But if your lookup range is Named "Data", just change each instance of the range to "Data" in your formula. Like this: OFFSET(Sheet1!$A$1,MATCH(MAX(Data),Data)-1,COLUMN()-1) Note there are no quotes "" in the actual formula when using a Named Range. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
named range and link | Excel Worksheet Functions | |||
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) |