If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|