E
Ed Bitzer
I need a named range for a cell on each of 12 (months) worksheets that
applies to the selected sheet, for example Cash on the selected sheet.
If I select all the sheets (group) and enter the range name, it is
specific for the sheet entered, such as Jan.Cash. Is there away around
entering named ranges that refer to each sheet without having to enter
into each sheet individually? I did find that if I copy Jan and then
rename the sheet, the range assumes the sheet name. This is fine for
initial creation but not latter updating.
Ed
applies to the selected sheet, for example Cash on the selected sheet.
If I select all the sheets (group) and enter the range name, it is
specific for the sheet entered, such as Jan.Cash. Is there away around
entering named ranges that refer to each sheet without having to enter
into each sheet individually? I did find that if I copy Jan and then
rename the sheet, the range assumes the sheet name. This is fine for
initial creation but not latter updating.
Ed