Hello. I have a spreadsheet that automatically puts rows 1 through 6 onto each worksheet after number one.
I have a need to keep these lines there but also take the information contained in rows 11 through 15 just under the top ones.
I want to skip lines 7 through 10 altogether.
I need a macro to do this and then I would eliminate the sheet formatting to have 1-6 appear on each sheet.
Is this possible? thanks in advance. Bob Reynolds