Hello,
I have a spreadsheet that feeds from a database. If it meets the criteria
of an "HL" call in a particular field, it shows on the spreadsheet, no
problem. What the spreadsheet is for it to notify when and "HL" call comes
up so the user can handle the call quickly. They change it from "HL" to a
variety of different things and it comes off the list like it's supposed to.
The problem is that when the field is changed from "HL" to anything else,
like it is supposed to, the spreadsheet changes all of the calculation fields
to REF#! because the cell goes blank.

Is there a way to fix this?
I've seen spreadsheets that automatically copy the row above when something
goes into the row below?

Thank you in advance for any help you can give me.
Gee

I think I figured it out!
I put in a routine to "SAVE" on Activate that seems to have solved the
problem.


"Gee" wrote:

Hello,
I have a spreadsheet that feeds from a database. If it meets the criteria
of an "HL" call in a particular field, it shows on the spreadsheet, no
problem. What the spreadsheet is for it to notify when and "HL" call comes
up so the user can handle the call quickly. They change it from "HL" to a
variety of different things and it comes off the list like it's supposed to.
The problem is that when the field is changed from "HL" to anything else,
like it is supposed to, the spreadsheet changes all of the calculation fields
to REF#! because the cell goes blank.

Is there a way to fix this?
I've seen spreadsheets that automatically copy the row above when something
goes into the row below?

Thank you in advance for any help you can give me.
Gee