named range and link

N

na

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)
 
N

na

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
 

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

named range link 1
Drop Down with dynamic named range offsheet source list 14
Excel VBA 1
Named Range maker code 9
Dependent drop down dynamic range formula, off sheet. 7
Creating a high performance dynamic name 2
Why did I use array formula - help 7
Sumproduct Indirect Named Dynamic Range using Offset 6

Top