Hi,
I recently have been trying to write a macro which will copy the ranges A1:37, paste it a few rows below and then copy B1:37, paste it in the column alongside the copied A values and keep looping this process(keeping the A1:37 but changing B to C, D, ect until it reaches QI).
As it's quite hard to explain, here's the recorded macro of the intial process. I would like to know the commands which will change B into a variable so I can keep moving one column along; pasting it below the previous pasted content- and the correct IF syntax to end the macro once it reaches QI.
Many thanks
And here's mine
Bookmarks