I need a macro that will cut a selected row from a master sheet and paste it into a secondary sheet but
only paste to the next blank row (eg: sheet 1 row 1 – cut and paste into sheet 2 row ? if empty)
I’ve recorded a macro that will cut and paste a row to its equivalent row but the rows being moved could be 10 rows apart which is what i get in the second sheet at the moment.