Remove Empty Row Upon Close

[Logit]

How would the attached file code be ammended to remove a blank row and then move all remaining rows below up one ?

Example: Open the attached file (Transport Log version 1). If you double-click in cell "X10" (for patient Abe Lincoln), the data for row 10 will be removed and written to Sheet #2. Closing the file and reopening, row 10 is empty with other rows below remaining. The goal is to move the data in rows 11 and 12 (and any subsequent rows that may be entered below those) up one row.

The above method would be an indication to users making subsequent entries to always use the first empty row below all existing data.

Thank you for your assistance.

[JBeaucaire]

Your macro appears to already have the answer in it, just commented out. I don't think you need an additional macro for this. Why not simply:

Please Login or Register  to view this content.

Also, you can merge many of those "sections" into one code group. For instance, inserting a timestamp into all those columns P through W can simply be:

Please Login or Register  to view this content.