trying to write a macro that finds data based on cell value - Help Please

[rogeryung]

Hi, I have a workbook and I want to write a macro that searches a specific value ( could change) found in Cell a1 on worksheet b, but find it on worksheet C.

I know how to do a macro that searches on a specific value (hardcode text), but I want it to search on a cell reference where the value could change. Can anyone help?

Thanks

Roger

 

[RichardMGreen]

Instead of using your hardcoded text, you could substitute it with
Sheets("Worksheet b").range("a1").value

 

[rogeryung]

Perfect, that worked...I just didn't know the correct syntax.

Thanks so much!