Forum Discussion
Need help building VBA or excel macros for columns
So i need to consolidate data from a column on a different sheet to another. Essentially, i need this
| animal | qty | date |
| dog | 12 | Jan |
| cat | 11 | Mar |
| dog | 10 | jan |
| mouse | 6 | Jan |
Turned into this:
| animal | qty | date |
| dog | 22 | jan |
| cat | 11 | mar |
| mouse | 6 | jan |
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
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
