I don't know how to explain this the best, so I took a random screenshot to show it
The data list would be unpredictable and would vary, so I am thinking that I would have to build an array with the data in the datalist, and run a loop, etc
Ideally, it would generate the "Count Occurrences" table on a new sheet
I have attached an image to show what I am trying to do
As of now, I am taking a report from a program, copying the results into a table into Access, running a Duplicate query, copying those results back over to Excel and sorting the results in descending order.
Any help or pointers appreciated,
Thanks!
Edit: to add, I have limited Excel/Access usage (learned it back in Office 2000 and am being reintroduced, but used to also code in Visual Basic 3,4, and 5 when I was a kid). Therefore, I have some technical aptitude, but am just very rusty at the moment and having a hard time putting this all together.
Bookmarks