Need help building VBA or excel macros for columns

New Contributor

So i need to consolidate data from a column on a different sheet to another. Essentially, i need this



Turned into this:


I'm trying to consolidate the columns on rules of category and date, while adding up the qty of the category. 

Can anyone help me with this? I have spent the last 5 hours trying to code this out or create rules with an action button and have nothing to show for it.

3 Replies

@Noxie I think PowerQuery or inserting a Pivot Table would be a better option to group your data by the 'animal' column. Can share the workbook, removing any sensitive data

@adversi  here is a file with data removed.  i'm trying to consolidate qty by item number and date. So all items that falls in january under item number 12345 would sow as a single row. Any ideas? I've tried using pivot tables but im making this for someone else, and requiring them to count is not realistic... I highlighted the fields as well

@Noxie Apologies for the delay -- a Pivot Table should be able to do this for you. See attached a sample workbook