'Take the formula from the adjacent cell and slightly alter it

Trying to automate some boring/a lot of copy and pasting similar formulas with macros, and thus have been trying to use macros to automate this. I'm stuck when it comes to how exaclty to do this though.

For example, I need to copy "='Worksheet2"!F5" and paste in the adjacent cell as "='Worksheet2"!G6"

I can't just click and drag and have excel do it for me, because the columns in Worksheet1 (where this copy and pasting is going on) are not the same as Worksheet2

Further, I need to copy from Worksheet3, 4, 5, 6, etc.

Thanks

excel vba

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution	Source

'Take the formula from the adjacent cell and slightly alter it

Sources

Related Questions