I have a workbook that tracks sales people production. All sales people will enter information about the sale on one sheet. This information includes the date(B5:B2000), client name(H5:H2000), sales person name(A5:A2000), the type of product(F5:F2000), and the company that provided the product(E5:E2000).
I would like to aggregate this information on a separate sheet by clicking a button. The info needs to be moved to a row on the sheet based on the company that provided the product (E5:E2000) and only if the sale was made that month (B5:B2000) in order for us to calculate what we pay the sales person. The data on the sales input sheet may be sporadically placed, for example, it could be in row 7, 10, 23, 48, etc. It's not necessarily one-after-another. I would like the data to display on the second sheet without any empty rows.
I attached an example of what I'm trying to do. Any help would be appreciated.
Bookmarks