I'm looking to run a series of copy pasting and duplicate row macro.
I need to:
(1) Copy paste y2:z2 to ab2:ac2
(2) Autofill ab2:ac2 to last row (data in column to the right)
(3) Copy paste ac2:ae* (eg ae18) to another sheet (a2:c*)
(4) Copy paste y3:z3 (until last row of...