linking data

G

Gai

I know how to set up links so dates on a Production Master schedule, that
show the dates that boats the firm I work for import will arrive will in
Australia off ships will automatically change on a Commissioning schedule in
a different workbook.

What is causing problem tho' is that the data in the source worksheet has to
be re-sorted when data alters and once the cell reference of cells that have
been linked alters the link doesn't seem to move to the new cell....as a
formula would.

A fellow worker has suggested that it may be called a "Special Link" but I
have got lost in searching for information and hope this posting may find an
answer... Gai
 
F

Frank Kabel

Hi
this is not possible with directly linkes formula references. If you
have an ID in your other file you may be able to use VLOOKUP for this
task.
 
Top