Sorting data in a table by date

Hi All,

I have macro which creates a table and attaches it to an email. Is it possible to arrange this data so that the table is essentially split into 2 tables, where the first rows of the table show the data from yesterdays date (column b), and then below this data there is a line in the table that says "Running total" and then the data from all the other dates is underneath this.

Here is the code:

Please Login or Register  to view this content.

Can anyone help me out?

Thanks!

Tee

cross posted http://www.mrexcel.com/forum/showthr...-table-by-date

Can anyone assist? I was thinking if it is too complicated to do, maybe it is possible to highlight the rows in the table where the date (column b) is equal to yesterdays date?