A macro that doing this steps

[Unexpc]

Hi guys
when i add a customer sheet, i doing this steps for change sheet for new customer, is there any macro that doing this?
insert new sheet:
1- duplicate sheets that named Sheet and Print and renamed with correct order number
2- going to sheet Print and doing this 3 step
3- edit formula in link cells for enter correct range & text (for sum cells in page 2 edit specific range that linked) and then drag and fill with change font for some cells
4- colored first and end page of sheet
5- enter customer name (sometime needs change format cells of date column)
6- print sheet from Sheet for testing print sheet and invisible sheet Print
7- write special code (this is in view code of Sheet) in new sheet code
8- then add new customer in customer list with formula like other customer
9- place in correct order belong tab sheets

 

[Zot]

This is hard to imagine. I think you probably will not get the answer for this.

I suggest that you break it down and ask question one by one by each step. Later combined them for solution.

 

[Unexpc]

This is hard to imagine. I think you probably will not get the answer for this.

I suggest that you break it down and ask question one by one by each step. Later combined them for solution.

Yes i thought like you, thank you