How to I change link of where to get data from

[shreked12]

Hi

I have a workbook that has linked data via copy and paste special.

I'm trying to save as a new book with same formula etc but get the data from another location for copy and paste special.

Is there anyway I can change without keep having to copy and paste all the links again.

Thanks

 

[DSCfromCFA]

If the source cell addreses are the same, you could try Replace (found under the Find & Select icon on the right of the home ribbon).