Forum Discussion
Noxie
Jan 20, 2021Copper Contributor
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 Tur...
Noxie
Jan 21, 2021Copper Contributor
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