Good Day All,
I am working on project estimating workbook. I have currently have 12 worksheets within this file. First sheet is labelled "Project Page", second sheet is labelled "Labor Break Down", subsequent sheets are default to sheet 3, sheet 4, etc..... Is there a way we can rename worksheets 3-10 based on cell data entered on the first worksheet that is labelled" Project Page". So if I enter "PKG-10" in cell A1, "PKG-20" in cell A2, "PKG-30" in cell A3 of the "Project Page. Then worksheet #3 gets relabelled to "PKG-10", worksheet #4 gets relabelled to "PKG-20", worksheet #5 get relabelled to "PKG-30" etc... The data entered into cells A1 thru A10 will vary from project to project. This relabelling will need to be automatic without the need to run a macro if possible. If macro is required, I can insert a button on the "Project Page".
Alternately is there an easier way to have the sheets rename based on cell data entered into A1-A10 of the "Project Page" with the Name Manager within the Formulas ribbon tab??
I am working on project estimating workbook. I have currently have 12 worksheets within this file. First sheet is labelled "Project Page", second sheet is labelled "Labor Break Down", subsequent sheets are default to sheet 3, sheet 4, etc..... Is there a way we can rename worksheets 3-10 based on cell data entered on the first worksheet that is labelled" Project Page". So if I enter "PKG-10" in cell A1, "PKG-20" in cell A2, "PKG-30" in cell A3 of the "Project Page. Then worksheet #3 gets relabelled to "PKG-10", worksheet #4 gets relabelled to "PKG-20", worksheet #5 get relabelled to "PKG-30" etc... The data entered into cells A1 thru A10 will vary from project to project. This relabelling will need to be automatic without the need to run a macro if possible. If macro is required, I can insert a button on the "Project Page".
Alternately is there an easier way to have the sheets rename based on cell data entered into A1-A10 of the "Project Page" with the Name Manager within the Formulas ribbon tab??