Searching select sheets for a value and identifying locaion of data

[Whita]

I'm very new to VBA and really don't know what I am doing.

I am trying to create a search within excel that will search only two sheets to find a value. I have the below that will search one sheet but I can't get it to search the second without running a separate second search.

FYI - This was poached from friend so there is likely a better way to approach this.

Please Login or Register  to view this content.

Also I would like excel to select the cell for me instead of the text box if possible. If not then copy a cell before the text box appears.

[nigelog]

If the search values are unique reference numbers this should work

Please Login or Register  to view this content.

[Whita]

The reference numbers are unique on the two sheets I want searched. However they so appear elsewhere in the workbook.

Will this work with other sheets in the workbook that i do not want searched? There are other sheets that will also contain the information but do not want excel to look there for it.