What type of data is in ColumnA & H?

Do you import into both columns?

And if you do, I don't understand exactly what data you're trying to retain.

Doesn't the newly imported data overwrite the "old" data?
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"NTaylor" wrote in message
...
Oh.. Like in one cell:

=SUMIF(ImportData!A:A, IDEA!A1412, ImportData!H:H)

I have a whole bunch of these set up in my sheet. I import the data once
a
day for our daily sales. It automatically fills in the cells with my
import.
But then some of that data expires, so I don't report on it any more. It
is
no big thing to have to copy and paste special to values... it would be
nice
if it could do the formula, but if the data wasn't there, just keep the
last
value it had set. Does that make sense?
--
Nicki Taylor


"RagDyer" wrote:

Copy some of the formulas that are returning 0 in your sheet and paste
them
in a message (post) in this thread, just like you did when you told me
you
didn't understand.

That way, folks here can see exactly what your formulas are doing, and
can
suggest various solutions to your problem.
--
Regards,

RD


--------------------------------------------------------------------------
-
Please keep all correspondence within the NewsGroup, so all may benefit
!

--------------------------------------------------------------------------
-

"NTaylor" wrote in message
...
I am sorry but I don't know what that means.
--
Nicki Taylor


"RagDyeR" wrote:

Post your formula.
--

Regards,

RD


--------------------------------------------------------------------------
--
-------------------
Please keep all correspondence within the Group, so all may benefit
!


--------------------------------------------------------------------------
--
-------------------

"NTaylor" wrote in message
...
I have a worksheet that automatically updates everyday and works
some
calculations for me. How can I get the formula sheet to keep the
value
from
the previous day if there is no data today. Because now it is
filling
in
all
my cells with zeros. Thanks
--
Nicki Taylor