| 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) |
| 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) | |||
Threaded Mode
