#ref error

[xcaliber13]

I have a spreadsheet with 13 worksheets in it. The worksheets are the months of the year and the last worksheet is a totals sheet.
I import data into each monthly sheet and total the data in the totals sheet.

Here is the formula: =IF(ISNUMBER(SEARCH("DATA",JANUARY!A130)),JANUARY!C130,"")

Once I import the data into the monthly worksheet and than delete the imported data my formulas on the totals sheet change to:

=IF(ISNUMBER(SEARCH("DATA",JANUARY!#REF!)),JANUARY!#REF!,"")

How do I stop this from happening?

Thank you

[Jonmo1]

Try using ClearContents instead of Delete when you remove the imported data.

[AlKey]

You need to copy and paste back Special, Values only before importing data. This will remove formulas and leave values.

[ChemistB]

Where are you deleting the imported data, from January!?
Do you want to convert the formulas in the Total sheet to constants?

[xcaliber13]

Jonmo1

That did it. Just what I was looking for. Thank you

[Jonmo1]

You're welcome.