Hi,
Does anyone out there know if it is possible to automatically rename a sheet by linking it to a cell in the sheet? I have created a consolidation workbook in to which I paste values from similar reports for different production sites and it would be useful to have the sheets re-named with the site names by reference to a cell in each sheet. (At present I re-name them manually).
Thanks, pignick
Does anyone out there know if it is possible to automatically rename a sheet by linking it to a cell in the sheet? I have created a consolidation workbook in to which I paste values from similar reports for different production sites and it would be useful to have the sheets re-named with the site names by reference to a cell in each sheet. (At present I re-name them manually).
Thanks, pignick