ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Putting multiple rows of data at the top of each sheet (https://www.excelbanter.com/excel-programming/453912-putting-multiple-rows-data-top-each-sheet.html)

[email protected]

Putting multiple rows of data at the top of each sheet
 
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


All times are GMT +1. The time now is 02:48 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com