Ben has attended:
Excel Intermediate course
Excel Advanced course
Source data moving
Hi,
I have a simple formula that copies a number from one (master) workbook to another (=\\file ref\\cell ref).
When the master is updated the new figure copies across to the destination workbook, which is what I want it to do, however when the cell on the master workbook moves (which it will do) the copy data is lost. Is there a way that I can update the formula to "follow" the moved cell on the source workbook?
Thanks,
Ben
RE: Source data moving
Have you tried special paste?
Just a thought..... regards Rachael