Prev: Suggestions to start programming in Excel
Next: Retrieving current custom sort settings
From: Gee on 24 Feb 2010 13:04
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
From: Gee on 24 Feb 2010 16:16
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
 | 
Pages: 1
Prev: Suggestions to start programming in Excel
Next: Retrieving current custom sort settings