Add new row at the top of the sheet

[JimmyG.]

Hello,
I have a spreadsheet detailing customer appointments, I want to keep these in reverse date order so the most recent is on top however rather than sorting or manually adding a new row, is there a way to have a macro add a new blank row (but that would copy any formulas and data validation) at the top when the last entry has been completed?

[TMS]

It's possible. I would suggest that you add (if there is not already one) a column at the end for a "completed flag". You could then monitor this with a Worksheet_Change event and, when set, add a new row.

When you say "at the top" I assume that you don't actually mean that and have a header row?

Best to upload a sample workbook for a specific response with formulae and DV.

Regards, TMS

[xladept]

Hi JimmyG.,

You could try something like this:

Please Login or Register  to view this content.