G
Grey Old Man
I am writing an Excel 2002 template, and wish to convert a large range of
imported data.
All of my formulae have been written in row A on a ‘Reformatted Data’ sheet.
For example cell A1 contains =TEXT('Imported Data '!B3,"00").
The many formulae work successfully, but I need to delete the entire
contents of the ‘Imported Data’ sheet. As a template it needs to be empty.
Obviously the formulae in my example cell is now =TEXT('Imported Data
'!#REF!,"00") because of the invalid cell reference.
My question is, how do I retain the formulae in the template? Or do I have
to use the ISERROR function on all of them?
Thanks in anticipation.
imported data.
All of my formulae have been written in row A on a ‘Reformatted Data’ sheet.
For example cell A1 contains =TEXT('Imported Data '!B3,"00").
The many formulae work successfully, but I need to delete the entire
contents of the ‘Imported Data’ sheet. As a template it needs to be empty.
Obviously the formulae in my example cell is now =TEXT('Imported Data
'!#REF!,"00") because of the invalid cell reference.
My question is, how do I retain the formulae in the template? Or do I have
to use the ISERROR function on all of them?
Thanks in anticipation.