linking data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 

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

Back
Top