source data moving

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Source data moving

Source data moving

resolvedResolved · 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

RE: Source data moving

Have you tried special paste?

Just a thought..... regards Rachael

Tue 30 Aug 2011: Automatically marked as resolved.


 

Excel tip:

Counting Blanks

Some times you want to check if there are cells missing data in your range. You can use the COUNTBLANK FUNCTION to acheive this. It is =COUNTBLANK(Range). Note Cells with formulas that return "" (empty text) are also counted. Cells with zero values are not counted.

View all Excel hints and tips


Server loaded in 0.08 secs.