Ambiguous_Fink
New Member
- Joined
- May 19, 2022
- Messages
- 1
- Office Version
- 2019
- Platform
- Windows
I know that's about as clear as mud, but let me explain: I have to track scans per address, per month. My data is similar to this although for 3272 properties and with the potential for multiple scans per day:
and I need it to look like this:
I had previously used a VBA Module that I had found but that was over 2 years ago and for the life of me I cannot locate the information or get the data to work. I'm not worried about it sorting by address, I just need to combine all the results for 1 address into 1 row to show each month's totals as I can manipulate it from there.
Address | January | February | March | April | May |
15 Oak Glen | 1 | ||||
17 High Ridge | 8 | ||||
15 Oak Glen | 6 | ||||
4 Blueberry | 1 |
and I need it to look like this:
Address | January | February | March | April | May |
4 Blueberry | 1 | 0 | 0 | 0 | 0 |
17 High Ridge Run | 0 | 8 | 0 | 0 | 0 |
15 Oak Glen | 1 | 0 | 0 | 6 | 0 |
I had previously used a VBA Module that I had found but that was over 2 years ago and for the life of me I cannot locate the information or get the data to work. I'm not worried about it sorting by address, I just need to combine all the results for 1 address into 1 row to show each month's totals as I can manipulate it from there.