Forum home » Delegate support and help forum » Microsoft Excel Training and help » Source data moving
Source data moving
Resolved · Medium Priority · Version 2007
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
For upcoming training course dates see: Pricing & availability
RE: Source data moving
Have you tried special paste?
Just a thought..... regards Rachael
Tue 30 Aug 2011: Automatically marked as resolved.
|
