Help !!!!! I need some vb to organise example list below what I need
is for category to have type after it, the earliest date only &
number
on the day & the total
EXAMPLE
Type : Cancel
Category : Cards
Receipt Date : 2009-04-20 1
Receipt Date : 2009-04-23 2
Receipt Date : 2009-04-24 1
Receipt Date : 2009-04-28 4
Receipt Date : 2009-04-29 5
Receipt Date : 2009-05-22 1
Total for Category : Cards 14
Category : Payment Due
Receipt Date : 2009-04-19 1
Receipt Date : 2009-04-21 1
Receipt Date : 2009-04-23 1
Receipt Date : 2009-04-28 1
Receipt Date : 2009-04-29 1
Total for Category : Payment Due 5
Total for Type : Cancel 19
RESULT NEEDED
Description Earliest Date
Amount Total
Cards - Cancel 20/4/09
1 14
Payment Due - Cancel 19/4/09
1 5
--~--~---------~--~----~------------~-------~--~----~
-------------------------------------------------------------------------------------
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
-------------------------------------------------------------------------------------
-~----------~----~----~----~------~----~------~--~---
