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

source data moving

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

Source data moving

ResolvedVersion 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:

Create Charts with One keystroke

Create a graph with one click

1. Select your data.
2. Press F11.
3. You have a graph.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.09 secs.