On the attached worksheet on "Home Page" I enter the client name on cell B4 and click the command button below it. This copies worksheets "Yearly Lease Order", "Yearly Quote Form" and "Yearly Invoice Form" and adds the contents of worksheet "Home Page" cell B4 to the copied worksheets names. ie if "Test" is in B4 then the new worksheets are called "Test Yearly Lease Order", "Test Yearly Quote Form" and "Test Yearly Invoice Form". The problem is the formulas in the new worksheets "Test Yearly Quote Form" and "Test Yearly Invoice Form" are still referencing "Yearly Lease Order". I need them to look at the newly created "Test Yearly Lease Order". Somehow I need to run a replace on "Test Yearly Quote Form" and "Test Yearly Invoice Form" to replace "Yearly Lease Order" with the contents of "Home Page" cell B4 & "Yearly Lease Order" I would like this happen with the same initial click of the command button.
Any Ideas anyone?????
Bookmarks