Add exception for blank cells/move new data to bottom of sheet

Hi all,

The below macro i have been working on for a few days (with some good help from here), is now almost complete :D

There are a few bugs that i have come across

1. New Data being added brings up an error (maybe add an exception to move any new data to the bottom of the sheet).

2. Blank cells in the search column bring up an error (maybe add an exception to move any new data to the bottom of the sheet)

Any ideas on how to sort this?

Thank You

Please Login or Register  to view this content.