Reyno has attended:
Excel Intermediate course
Excel Advanced course
Moving data already containing links
At the moment i have a work sheet with input data at the top and all the other information underneath and as i change the input data the other data changes as appropriate. I would now like to move the input data to a different worksheet but i want the links to stay so if i change the input data my other data (on a different sheet now) still changes. how would i go about this?
thanks
RE: moving data already containing links
Hi Reyno
Thanks for your question.
You should be able to just cut and paste the input data into another sheet, and the formulas should update themselves so that they refer to the same input data.
Try it out with a small amount of data first before trying it with the worksheet you refer to in your post.
Please put another post onto our website if you find that you do have problems with moving your data.
thanks
Amanda