Thread: Linking Data
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
RickComputer RickComputer is offline
external usenet poster
 
Posts: 6
Default Linking Data

Thank You

"Tom Hutchins" wrote:

Assign a range name to the cell in the source worksheet. If the cell gets
moved, the formula in the linked worksheet will still work.

Hope this helps,

Hutch

"RickComputer" wrote:

I am able to link data from an external source between worksheets if the cell
remains the same on the opposing worksheet.
How can I link this data from an exteranl source if the cell changes on the
opposing work sheet ?