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

training excel vba - moving data already containing

Forum home » Delegate support and help forum » Microsoft Excel Training and help » training excel vba - Moving data already containing links

training excel vba - Moving data already containing links

ResolvedVersion Standard

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

Excel tip:

Creating Quick Column Charts

Select the information you want to appear in the chart and press F11. This creates a new chart on a seperate worksheet.

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.