good morning all.

this is a little complicated, so ill start from the beginning....

and before you ask, i dont have access and cant get it, hence why i am using
excel,

i have a workbook, there are two work sheets which contain various data, but
ideally should be kept separate as they are for separate years.

i have written a macro which will search the sheets for a specific name or
reference number, then will highlight the row where that cell lies.

here is the problem...
if the file opens on sheet one and i search for a specific name which i know
is on sheet two, then the corresponding row is highlighted in sheet one.
how do i write into the code so that it highlights and then makes it active
so you can see it on sheet two were the actal name is?

if you need to see the code that i have at the moment let me know and i will
add it in.
thanks

mike