Insert a row and get subtotal

[norman+10]

Hi Everyone,

I'm working on a huge data daily with multiple columns on it. The data set includes prices, orders, material type and dates. Those lines are being bucketed on multiple tabs based on specific criteria. I have worked on the formula and macro to bucket each row to their respective tab. I'm just wondering if there is a macro code that would allow me to insert a row after a given date in reference to a specific column. Because I'm trying to get the sum of amount of late rows (based on today's date).

Hope to hear from you.

Thanks!