Is there some simple VBA code that will allow me to:
copy the 'names' in the named cells referring to cells in worksheet one and offset those names with a text prefix (i.e. tab2'cellname') and apply these new names to identical ranges in worksheet two?
Any help appreciated.
copy the 'names' in the named cells referring to cells in worksheet one and offset those names with a text prefix (i.e. tab2'cellname') and apply these new names to identical ranges in worksheet two?
Any help appreciated.