How to have Macro replicate page layout indefinitely...

**Aceofd1amonds** · 10-11-2010, 08:17 PM

Hello! New user here. Trying to figure out some of this deep, Excel magic you guys know so well. Here's what I'm trying to do:

I created a Macro to replicate the complete printable area of Page 2 to Page 3. I plan on making a button for the Macro and putting it at the top of Page 2. When I click the button I need it to make Page 3 complete with button so that I can click that button and it will make Page 4.

What's currently happening:
I run the macro and it copies everything, formulas included, from Page 2 and makes Page 3. If I run it again it simply makes page 3 again in the same spot.

How do I make this macro generic enough to copy the same data and formulas in the same layout, but not in these specific cells?

Thank you for the help!
-Kade

**shg** · 10-11-2010, 08:21 PM

dWelcome to the forum.

Did you know you can click a tab, press and hold the Ctrl key, and drag the tab to the right (or left) to duplicate the entire sheet?

**Aceofd1amonds** · 10-11-2010, 08:28 PM

I didn't! That would work if I were the only person using this form, but I'm really hoping that I can do it all in one sheet. That will make it easy to print. Do you think that I would be better served by creating a button for your method then printing each sheet?
-Kade

**shg** · 10-11-2010, 08:34 PM

Do you think that I would be better served by ...

I don't know what you're trying to do

**Aceofd1amonds** · 10-11-2010, 08:45 PM

I think I just uploaded my workbook. If you look in macros and run the NewBuild Macro it will show you what I'm trying to do. After that I just want to have a button at the top of each new page that makes another page.

I need to be able to add as many machines as needed to satisfy the customer.

Btw, I miss TEXAS so bad!!

-Kade