Every morning I run a db query that returns a result set in excel. Needless
to say, there's a great deal of "massaging" that needs to be done to that
'raw' data. Once it's formatted correctly, I have to copy it to another
workbook called "[ThisMonths]Daily Numbers". I then upload it to the
intranet site where anyone can view the daily numbers.

Probably about 90% can be recorded as a macro, but the other 10% requires a
little VBA. Here's the problem:

There are some records that get deleted based on their vendor name. Also,
there are an even larger number of records which get moved to the "zero"
sheet in the "Daily Numbers" workbook whose 'total' cell equals 0. What I'm
left with is the usable data that is to go into the "Numbers" sheet of the
"Daily Numbers" book.

It gets tricky though, because as the month goes on, the "Numbers" sheet
grows downward. But there's formulas that need to go into each days data.
But the daily data is dynamic, some days I might have 20 records, other days
I might have 45. No way to know. Maybe a 'count' function could add 'em up
and ... AAAHH!!

I know I didn't do a really good job of illustrating my daily madness... but
if anyone has any ideas that might help to automate this crap I'd appreciate
it.

Thanks
Dan