I tried to modify your code and kept getting debugged
I have uploaded a mock up of the workbook I am working on.
I have blacked out fields in the search engine as they will never be used to search so can be ignored.
The master dataset is where the information is coming from and will be 1000 rows.
Everything is in the right place.
Hope this is not too complicated.
Cheers for your help, really appreciated