Worksheet Total and Macro
 

The purpose of my Excel workbook is to track vendor PO's that have been sent
and acknowledged. I have seven identical worksheets with the only difference
being the time of the day I am reporting on.

On each worksheet has all the vendors down column B (which are really a
"sent" and "acknowledged" row merged) and to the left in column A I have
divided the vendor rows into each having a "Sent" and "Acknowledged" row. In
row 1 are heading dates for each vendor with the current date at row 1 column
C. I have the vendors in column B because It is easier to read. I have
highlighted all the Acknowledged rows

Illustration:


Current Date YEsterday
Sent. VEN 1 1
Ack. DOR 1 1


What I need is a totals sheet for sent and ackn. for every vendor that adds
up all the sheets (times which I receive the reports).

I have managed to get a totals sheet that does this (kind of).

What I also want is a macro that every morning when I come in I can run it
to do a few main things.

1. Print out yesterdays totals that is greater than zero. Out of 50 we get
about 10 send and receive.
2. Insert a new column into all the sheets at column C for the new current
day and auto insert the current day into the header (rw1 clC)
3. maintain my formating (background fill) for my rows. (used on all ack.
rows.)



I have a product very close but when I run it and the macro inserts the new
column the totals sheet does not stay at reporting only the figures in Column
C... it shifts over and starts reporting on D.

I think I need to know what combination of chars (# I assume) I need to use
so after I insert the new day for all sheets the total sheet is still only
looking at column C.

I have excel 2k3.

Thank you for all your help in advance.


-Rob H