98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum 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
RE: Source data moving
Have you tried special paste?
Just a thought..... regards Rachael
Tue 30 Aug 2011: Automatically marked as resolved.
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Counting BlanksSome 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. |