Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old September 16th 08, 04:51 PM posted to microsoft.public.excel.worksheet.functions
NA NA is offline
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2008
Posts: 12
Default 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   Report Post  
Old September 16th 08, 05:13 PM posted to microsoft.public.excel.worksheet.functions
NA NA is offline
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2008
Posts: 12
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Print Named Cells highlights web link to Excel range ExcelMonkey Excel Discussion (Misc queries) 1 June 12th 08 11:46 PM
Excel2000:How to link Print Area with a named range Arvi Laanemets Excel Discussion (Misc queries) 5 April 8th 08 02:35 PM
Excel2000:How to link Print Area with a named range Arvi Laanemets Excel Worksheet Functions 5 April 8th 08 02:35 PM
Link to a named range in another worksheet that is sorted frequent ShortBlonde Excel Worksheet Functions 2 March 18th 08 03:32 PM
External link to Named Range Fleone Excel Discussion (Misc queries) 0 December 18th 07 08:52 PM


All times are GMT +1. The time now is 10:43 PM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017