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
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