VBA/Macro Help: Copy and Paste x rows above, then find and replace, repeat

[felix.dwa]

I'm wondering how to build a macro which is essentially a structured copy and paste combined with a find and replace function.


I've attached an excel file with three columns. Basically I want to copy x rows from the original/source. I then paste it below and replace column B with something else. I then copy the same original source rows and paste it below and replace it with something else again.


Then I do the same but with column C.


Is this something that's possible? I would love some guidance. Please kindly advise.