Create a new list and count occurrences

[dagindi]

I apologize if the title of this is a bit vague but I can't figure out another way to describe what I am trying to do...

Attached is an example of an edited report I run at the end of each day. Note that the length of the report varies from day to day (it's dependent on how many orders are entered on a given day).

I am trying to list all the Cust IDs (D707 to D760) on a new page and then in the next column total the amount of orders that were entered for that Cust ID.

Im running into the following problems

1. Starting on a new page
2. Spaces in the new list caused by the subtotaling of the main list
3. Totaling the orders by CustId.

I added Sheet2 with the code I am currently using to get to this point along with what I've worked on so far:

Sub EOD_Daily_Sale() - This is the main code that converts my raw data to the finished spreadsheet (& PDF).

Sub EOD_Daily_Sale_test() - This is the start of the code to compile the list and copy it to the end of the sheet. Keep in mind that this sheet changes every day so I would like the list to begin 2 or 3 rows after last row (which has the Grand Total).

Sub Macro2() - This is where I got stuck after I remove the duplicates in the list.

Any help would be greatly appreciated.

[danielexcelvba]

I think this is what you're looking for. I wrote a macro in module 1. Run it, and let me know if that's what you were asking!

Edit: this will only work for 100 or less User IDs (see the end of the code). Not sure why but using .resize(, last2) wasn't working for me

[jaslake]

Hi dagindi

Here's another approach...CTRL + k will run the Code...

Please Login or Register  to view this content.

[LeoTaxi]

other 1

Please Login or Register  to view this content.

Kind regards
Leo

[dagindi]

Some great stuff here! Thanks.

I played with each of them for few a minutes but not long enough for proper feedback. I hope to post more tomorrow, but thanks for the all responses and help!

[jaslake]

You're welcome...glad I could help.

If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.