Curiousintel
Technical User
I am trying to set up an excel sheet that can pick up a row and copy it to a another static row that is linked to a formatted print area.
Each row is individually copied and pasted down to the static row in succession for a range of rows.
What i need is firstly a way of increasing the row number picked up until a predfined row number is reached and also a way of picking up a cell reference in excel that tells the macro the range of rows to be copied and pasted.
I have the macro at present creating a new excel file and renaming the tabs to correspond with each row printed but the proceedure is cumbersome if the row range is changed.
Each row is individually copied and pasted down to the static row in succession for a range of rows.
What i need is firstly a way of increasing the row number picked up until a predfined row number is reached and also a way of picking up a cell reference in excel that tells the macro the range of rows to be copied and pasted.
I have the macro at present creating a new excel file and renaming the tabs to correspond with each row printed but the proceedure is cumbersome if the row range is changed.