Hello all firstly many thanks for taking the time to look at my problem, I have had some help in making this macro, which is a search records macro, to pull/import the records from one sheet to another based on a list of cells. It also tells me if a piece of record is not found. This is very useful! Because I canít then add these records, however it also displays the same message on encountering both blanks and titles. This causes many false positives with regards to needing to enter new records. I have included an example spreadsheet with macro.
So i would like to be able to add exceptions (blanks/"specific text") to the already supplied macro.
Any help would be greatly appreciated.