Hi,
Is there a way to share a defined data name range within the same workbook by most of the worksheets?
I have approximately 25 worksheets within one workbook that contains the same format but different type of data. As a header let us say cell $E4 is defined as CCGroup (Cost Center Group)
and in Cell $E3 the corresponding Cost center name will be displayed automatically based on the Cost center Group code.
All the sheets have exactly the same header but the value found in the cost center is different.
You help would be much appreciated.
Regards,
Chuck
Is there a way to share a defined data name range within the same workbook by most of the worksheets?
I have approximately 25 worksheets within one workbook that contains the same format but different type of data. As a header let us say cell $E4 is defined as CCGroup (Cost Center Group)
and in Cell $E3 the corresponding Cost center name will be displayed automatically based on the Cost center Group code.
All the sheets have exactly the same header but the value found in the cost center is different.
You help would be much appreciated.
Regards,
Chuck