Attatched is an example of what I am working on. I am trying to figure out(in VBA) how to sum TrksReq in column B based on plant number in column A. The sum must appear in the TOTAL areas. I have a macro that sends the sum to another workbook. Example 

A                                     B

                                      TRUCKS REQUIRED

      Plant:357           TOTAL           

357                                   28.00

357                                   10.0

      Plant:358         TOTAL 

358                                   30.0

358                                   10.0

     Plant:359         TOTAL

359                                   10.0

359                                   320.0

By: David

Leave a Reply

Your email address will not be published. Required fields are marked *