Pete
11-21-2008, 01:41 AM
See attached file
Hi Experts
How would you do the following. Current i have the first worksheet name in the workbook as "R_Share_Phase_1_Countries". I want this name to change automatically if the user change the this name in the worksheet also. i.e
1. User change current worksheet name R_Share_Phase_1_Countries to R_Share_Phase_2 then
2. Also change the name in column B cells B15, B28 and B41 i.e. section highlighted in yellow. With the user having to re-type this name in again and again
Hi Experts
How would you do the following. Current i have the first worksheet name in the workbook as "R_Share_Phase_1_Countries". I want this name to change automatically if the user change the this name in the worksheet also. i.e
1. User change current worksheet name R_Share_Phase_1_Countries to R_Share_Phase_2 then
2. Also change the name in column B cells B15, B28 and B41 i.e. section highlighted in yellow. With the user having to re-type this name in again and again