ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Compare data from different sheets and total how many times it appears (https://www.excelbanter.com/excel-programming/380853-compare-data-different-sheets-total-how-many-times-appears.html)

[email protected]

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