Thread: VBA - Searching Contents in Sheets if found then display else search in next sheet

Hi all,

I'm trying to write a code that will locate information in Sheet 1 and search for that same information in Sheet 2, then pull a different bit of information from Sheet 2 and place it back in Sheet 1.

How can i make a search in particular document means ?

I want to make a search by word or by phrase in my document if word found then display else search in the next page.

Any suggestions?