felix.dwa
11-04-2016, 09:56 AM
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.
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.