Hi Tejas
You had a few problems. Your cell formatting came through with different formats on each sheet & Find will never work like that. Find also has issues with dates, so you have to use text formatted properly. I used the american format as it looked like that's what you're using.
You should use error control with find, as it throws errors when it doesn't find anything.
I've attached your file with my code. Someone will most likely be able to do it in half the code lol. But this is how I do it.
Cheers
Phil
Bookmarks