Dear Experts,

At first, my sincere thanks to Holger and all other experts for extensive support provided. I need to develop a master to

maintain customer information, of which the excel spread sheet is attached.

It is already containing event macro, which does the following

1. Sheet1 - Column G is the master list of customers, which contains existing customer names.

2. For each of the existing customers, there is a separate sheet available, namely - Spencer, TATA, Ford, Kiwi.

3. The existing sheets - Spencer, TATA, Ford, Kiwi - cells A1 to R3 are password protected.

3. The customer name will be typed in sheet1 cell B5. If the name is in the existing list of customers in column G, then

excel should take me to the respective customer sheet (This function is not happening now, and for this also I need your

support)

4. If the customer name is not available in the column G, then it will be added in the column G, and a new sheet in the name

of new customer will be created at the end of the workbook.


Now my requirements are

1. The newly created sheet to automatically contain the tabular columns as in the existing sheets

2. Newly created sheet with tabular column should automatically protect the cells A1 to R3.

3. In the newly created sheet, Cell D1 to I1 to be merged, and it should show the name of the sheet (Name of the customer)

automatically.

4. If the name of the customer typed in the sheet1 is already existing in the column G, then excel should go to the specific

sheet having the name of the customer typed.


I know just copy and paste macro codes. I fully depend on experts like you for this. Can you please support to provide the

macro code for the above functions?


With sincere thanks for all

gm2612

Data Sheet1.xls