Ladies/Gentlemen,

I am trying to create a template that will be used to create hundreds of specification document. The top 11 rows are headers that will be printed on all pages. Row 12 to 49 & column A to V would be page 1, row 50 to 87 & column A to V will be page 2, etc (these are the main bodies). Row 12 to 49 & column W to AR, row 50 to 87 & column W to AR will form the last page(s) of the document (these are charts), they have a slightly different header. At the moment, only page 1 and the last page are formatted, some of the cells are merged, bolded, conditional format with formulas, etc.

I do not know how many pages of main bodies or charts each specification will have as they all vary. I would like to create a macro (button) that would copy all formats of the previous page and apply to the next. My current plan is to have the user select cell A50 (first cell of page 2), press the button to populate the next page.

I would not consider myself even a beginner when it comes to VBA. Any hints would be greatly appreciated.


Thank you.


M.