Thanks for your input Bob, but I am at work, and things like that need to be
put through the Head of IT, and requires form filling.
Its annoying, because I wrote the code and managed to get it working apart
from this slight adjustment which I need to make.


"Bob Phillips" wrote:

You can get MySQL, which is a free database.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"mike" wrote in message
...
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