Dear Experts,
Greetings. My sincere thanks for the support you provide time to time when I stuck with
some requirements in the microsoft excel. I request you to support me this time also.
I will have a master list of customers in the sheet1, column "G". I will enter the name of
the customer in the cell "B5".
I will have a specific sheet for each existing customer (existing in the master list) in
subsequent sheets, say sheetCustA, sheetCustB, SheetCustC...
1. If the entered customer name is already existing in the master list in column "G", then
after entering the customer name in the cell B5, the sheet will have to go the respecting
sheet with the customer name.
For example, I have the Customers A, B, C, D, E and R in the master list of customers. If I
enter "C" in cell "B5", then it should automatically take me to the sheet - "SheetCustC".
If the customer name I am typping is not existing in the master list of customers, then
1. it should create a new sheet in the name of the new customer,
2. It should copy the format from the previous sheet (Format is a common template for all
customers)
For example, in cell "B5", if I type "G", then it should compare with the master list of
customers, and since it is not appearing in the current customer list, it should update the
master list with "G", and should create a new sheet with called - "SheetCustG", and then
copy the format from previous sheet and paste it in the sheet - "SheetCustG".
Can anyone please provide me a macro for this application?
My sincere thanks for your support.
Thanks and regards,
gm2612
Bookmarks