Macro to sort, then insert headers

[geekboy101]

Hi All,

Hi All,

I have a spreadsheet that would contain a hundreds of thousands of invoices. But to simplify, I have attached a sample file where the data is condensed and much smaller.

To simplify matter, what I am trying to achieve is the following.:

1.) Sort via amount, and then insert a row and a header, between the positive values and negative values. This will then produce 2 different tables. Then sort the resulting 2nd table, via the oldest to newest.

2.) The resulting 1st table, will then have to be sorted under days overdue. ANd then do the same drill, insert a header, in between the positive and negative value.

3.) each resulting table then had to be labeled accordingly.

On the file, sheet 2 would show how I wish the file would look like. The formatting concerns, can be overlooked.
I understand that I may be being a bit lazy trying to avoid doing these manually, but we're talking about hundreds of thousands of transactions which means I have to do this repeatedly for different customers.

Thanks in advance for the help.

Sample.xlsx

[jaslake]

Hi geekboy101

Welcome to the Forum!

This Code is in the attached. It appears to do as you require on your sample File. Let me know of issues...

Please Login or Register  to view this content.

Be patient, the Code will take a bit of time to run on

hundreds of thousands of invoices

[geekboy101]

This works perfectly. Exactly what I need. I just have to edit a bit to match the actual name on the sheets and on the headers or locations on my actual file.
Hopefully I don't screw that up.

I'll post the finished product here once done. Thanks again.

P.S.
I'm very patient, and I devised a lazy way to minimize the number of rows involved. I decided to just copy part of the report into a paste area in the macro file, and run the codes from there.