There are 2 worksheets. Say I want cell A2 in sheet2 ALWAYS to equal cell A2
in sheet1. The data in sheet1 is cut and pasted quite a lot due to the way
we work and when this happens the link is corrupted. I think I could use
INDIRECT but there are quite a lot of links and if I used this method what is
the best way to set it up - does every cell have to be set up individually?
A lot of work!!!