Delivery Notes compiler macro

[makinmomb]

I have this data , I have manually done types those results of company 1 , need macro to skin me summary , I have 500 companies do this for , macro should do the magic in time needed

[makinmomb]

03/08/2017 company 1 0316308
07/08/2017 company 1 0319068
10/08/2017 company 1 0319513
14/08/2017 company 1 0317170
17/08/2017 company 1 0317678
21/08/2017 company 1 0320083
05/08/2017 company 2 0316787
09/08/2017 company 2 0319020
12/08/2017 company 2 0316679
15/08/2017 company 2 0319868
19/08/2017 company 2 0320103
22/08/2017 company 2 0320136

[makinmomb]

COMPANY 1 0316308 DTD 03/08 , 0319068 , DTD 07/08 , 0319513 DTD 10/08 , 0317170 DTD 14/08 , 0317678 DTD 17/08 , 0320083 DTD 21/08
COMPANY 2
COMPANY 3

Expected results from above without formula since number of records per client is not known

[makinmomb]

The macro needs to read endless rows , data maybe upto 9999 records and more

[JOHN H. DAVIS]

Maybe:

Please Login or Register  to view this content.

[nilem]

or maybe so

Please Login or Register  to view this content.

[makinmomb]

Thank you Nilem and John , works exactly as needed

[JOHN H. DAVIS]

You're welcome. Glad to help out and thanks for the feedback.