I have two sheets for two different pieces of equipment with the exception of the sheetname the sheets identical. I would like to copy the range names between the sheets changing only the first two characters. My current list is the top block of characters while the second block of charactrs is what I would like to create. there are 140~ range names per sheet. Alternatively if there is a better way to name the ranges I am open to changing the names again. the ranges (names) are used in other VBA and as references between sheets and workbooks.
Column A Column B
Name Refers to
b1day21x0ct ='Front page Block1'!$E$52
b1day21x0db ='Front page Block1'!$G$52
b1day21x0evaps ='Front page Block1'!$F$52
b1day21x0minload ='Front page Block1'!$D$52
b1day21x0total ='Front page Block1'!$H$52
b2day21x0ct ='Front page Block2'!$E$52
b2day21x0db ='Front page Block2'!$G$52
b2day21x0evaps ='Front page Block2'!$F$52
b2day21x0minload ='Front page Block2'!$D$52
b2day21x0total ='Front page Block2'!$H$52
Thank You.
Column A Column B
Name Refers to
b1day21x0ct ='Front page Block1'!$E$52
b1day21x0db ='Front page Block1'!$G$52
b1day21x0evaps ='Front page Block1'!$F$52
b1day21x0minload ='Front page Block1'!$D$52
b1day21x0total ='Front page Block1'!$H$52
b2day21x0ct ='Front page Block2'!$E$52
b2day21x0db ='Front page Block2'!$G$52
b2day21x0evaps ='Front page Block2'!$F$52
b2day21x0minload ='Front page Block2'!$D$52
b2day21x0total ='Front page Block2'!$H$52
Thank You.