A macro that doing this steps

Unexpc

Active Member
Joined
Nov 12, 2020
Messages
286
Office Version
  1. 2019
Platform
  1. Windows
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
 

Some videos you may like

Excel Facts

Control Word Wrap
Press Alt+Enter to move to a new row in a cell. Lets you control where the words wrap.

Zot

Well-known Member
Joined
Nov 26, 2020
Messages
1,060
Office Version
  1. 2016
Platform
  1. Windows
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

Active Member
Joined
Nov 12, 2020
Messages
286
Office Version
  1. 2019
Platform
  1. Windows
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
 

Watch MrExcel Video

Forum statistics

Threads
1,128,150
Messages
5,628,992
Members
416,358
Latest member
grsaltzman

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top