![]() |
Compare data from different sheets and total how many times it appears
I am new to writing excel macros and need some help with a project. I
have a workbook with 2 worksheets. Sheet1 has a master list of order codes in column A. Sheet2 contains a list of all the orders placed during the day, column A contains the order code, column B indicates the type "Verbal" or "Written", and column C indicates if it's a "Rush". What I am trying to do is find the number of times each order code was used, how many times that code was "written", "verbal", and "rush" and add those to Sheet1. So when the macro is done, Sheet1 would have five columns, "A" would be the master list, "B" would have the total number of times that code appeared in column "A" of sheet2, "C" would be the number of times that code appeared with "Verbal" in column "B" of sheet2, "D" would be the number of times that code appeared with "Written" in column "B" of sheet2, and "E" would be the number of times that code appeared with "Rush" in column "C" of sheet2. Thank you for any help with this. |
All times are GMT +1. The time now is 05:19 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com