Morning experts,
On Sheet2 A1:J6 contains static data which will always be there. A6:J6 being the headings of my filtered data. The filtered data can occupy up to A7:J51 maximum.
I'm trying to find a way of copying the first 6 static rows of static data (A6:J6) plus the filtered data below it and copy it to the first blank row on sheet3. I'd be obliged if anyone could start me off.
Regards Graham
On Sheet2 A1:J6 contains static data which will always be there. A6:J6 being the headings of my filtered data. The filtered data can occupy up to A7:J51 maximum.
I'm trying to find a way of copying the first 6 static rows of static data (A6:J6) plus the filtered data below it and copy it to the first blank row on sheet3. I'd be obliged if anyone could start me off.
Regards Graham