Edit: Also just noticed you changed d.Row to b.Row that's probably your error.
I thought you wanted to search FY_15_Hiring?
ws1 is whatever sheet has the "Vacancy" s on it
ws2 is whatever sheet you want to search for the matching number
If that doesn't help, please post your workbook or an example workbook that replicates the error.
Bookmarks