Copying Worksheets which contain Named Ranges
I have a workbook that has several sheets. On one of the sheets I have
named several ranges of cells and formulae in other sheets refer to these ranges. Each week I need to 'archive' the sheet which has the named ranges, ie; by simply copying it and re-naming it so that I can refer back to it should the need arise. The 'original' sheet is then updated throughout the week. When copying the sheet and moving it to another position in the workbook, the named ranges seem to change to refer to the copied sheet, even though it has been re-named. I don't want this to happen - I simply need the named ranges to refer to the original sheet, the name of which doesn't change week by week. Any guidance would be gratefully received! |
All times are GMT +1. The time now is 08:30 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com