source data moving
The UK's Number 1 for Microsoft Office Training Add this page to your favourites/bookmarksBookmark page
 
View printable version of pagePrintable version
Plus One Google
Customer: Sign in
Delegate: Sign in
Trainer: Log in

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

Source data moving

resolvedResolved · Medium Priority · Version 2007

replyReply Tue 23 Aug 2011, 09:57Delegate Ben said...

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

replyReply Tue 23 Aug 2011, 15:18Trainer Rachael said...

RE: Source data moving

Have you tried special paste?

Just a thought..... regards Rachael

Tue 30 Aug 2011: Automatically marked as resolved.

 

Please browse our web site to find out more about
excel vba courses london and other Microsoft training courses.

Excel tip:

Paste functions box quickly

If you want to do a formula using the paste functions box press SHIFT + F3.

View all Excel hints and tips


Microsoft Certified Partner Accredited Training Provider: Institute of IT Training Institute of Leadership and Management - Certified Courses Security Seal verified by visa, mastercard securecard