I am trying to create a routine to type in a surname and it will extract multiple rows of results where the name repeats. I have managed to identify the rows where the names appear, but when trying to index the results to extract all the completed cells on each row things are going wrong. I cant see any issues with my VB and am hoping it is something simple.
I have created a basic sample sheet where the data is in cells A5:E13, my input field is G4 and the results are B17 onwards.
Bookmarks