Finding value using loop

[phong919]

Hello all,

Can someone assist me with the following? I'm kind of new at this excel vba stuff. I will attach the spreadsheet. i'm trying to loop through the data and find a date value. There is a finish date column that i want to loop through and find the last row for that month and then insert a blank row.

[rylo]

Hi

try this.

Please Login or Register  to view this content.

you may want to make sure the data is sorted by column G before you action.


rylo

[phong919]

that works great! thank you for your help...