Find date in column, then insert row below it, and add values to a range inside that row.

I need to:

1. Search column F for a date stored as SEARCHDATE
2. Insert a row below the date.
3. Save the new row number to variable NEWROW
4. Change the values in range ("G" & NEWROW : "BM" & NEWROW) to the FORMULA of the cell directly above them. Basically, it would need to have the same effect as clicking the little black box in the corner of the cell above each one and dragging down, as it needs to update its cell reference to the new cell.

This is a lot harder than you might think.

Excel messes about with times and dates.

The best thing to do is to post a sample spreadsheet showing your dates and your search date.

Maybe:

Please Login or Register  to view this content.