Need help modifying a macro to insert rows after date change.

try this way:

Please Login or Register  to view this content.

and let me know...

Excellent! And thanks for the quick response.

So the code you posted does the initial 'inserting line before todays date'.

So can I then add the code in my original post after that to go through the rest of the sheets after todays date and add a line after each date change?

eg.....

Please Login or Register  to view this content.

Does the second part of the code need modifying to start after todays date? Much appreciated :-)

edit: It doesn't like having two Dim as Long. What can I change the second one to?

Can you attach the workbook so i can see the structure of the dates? Please hide any sensible confidential data.

Should hopefully be attached. I have removed some of the rows with sesitive data, so column 'M' (which did have the dates) is now column G.

I have also added the colour lines so you can see what I would like the end result to look like.

So there is normally between 0-10 rows before todays date. Then after that there could be any number of date groupings, as you should be able to see.

EXAMPLE.xlsx

So

Please Login or Register  to view this content.

Put this in a module and run it on the worksheet you need.

AWESOME! It works!

So I just needed to combine the IF statements.

Thank you very much for your help. Hopefully in a year or two I will know enough to help people like you do!

Glad to help. Mark SOLVED and Add Reputation if my answer pleases you.

Hello again bulina2K,

I wonder if you might be able to help make a slight modification to this. We have been a little too efficient here, and managed to get all the backlog product out of the door.

This means, that the first part of the macro that inserts a line before "todays date" comes back as a run time error, because there is nothing before "todays" date.

Is there a modification that can be added to the 'If' statement to ignore it if there is nothing before "todays date"?

Thanks again.

add this line of code first thing in Do loop

Please Login or Register  to view this content.

so:

Please Login or Register  to view this content.

let me know..

Sweet, that has fixed it. Many thanks once again. Wish I knew it was that simple!

Ignore, I'll start a new thread.