Pasting links that are in intervals

Hello. I want to paste links with same intervals at one go not by pasting one by one. Just like a1, d1, g1 , j1 ...... and goes on like this. to another row in another worksheet side by side. Any way to do this?

From what I understood from your question, I think u need to try "Paste Special" on right click?

Originally Posted by Vinodsralian

From what I understood from your question, I think u need to try "Paste Special" on right click?

Hello.

In example when we type 1, 3, 5 to the cells and extend a paste excel autocompletes and continues like 7, 9, 11, 13.

Can we do this to links too? I mean if I paste A1, A4, A7 from another sheet and extend the selection is there any way to make it continue the links as A10, A13, A16 until a large value. It is hard to select and paste one by one.

Originally Posted by DonkeyOte

A few options

If we assume links are on Sheet2 in A1, B1 etc to Sheet1 in increments of 3

Please Login or Register  to view this content.

thanks Donkey Ote!...

doesn't work for me =(