I am trying to get this to work I have my data laid out like this

Emp # Name '''''''''' Dept# '''''Shift'''Hire
Date'''''''''Jobcode''''''Jobtitle
121 '''''John Doe'''''' 2525 '''''''''' A''''''07/08/06'''''''' 56254
''''''''''' Job1
'''''''''''''''''''''''''''''''''''''''''''''''''' '''''''''''''''''''''''''''''''''''''''''''
25648 ''''''''''''Job2
'''''''''''''''''''''''''''''''''''''''''''''''''' '''''''''''''''''''''''''''''''''''''''''''
45465 ''''''''''''Job3

I am searching the jobcode column for a jobcode say 45465
I want to copy that jobcode and job title as well as the employee data
to a new worksheet list I can select what I need using this code

This code almost works
Worksheets("Data Entry").Activate
ActiveCell.Offset(rowOffset:=-2, columnOffset:=-5).Activate
ActiveCell.Range("A1:E1").Select

it Only Works if I find the 3rd code down 45465
But if I search for the second or the first codes the offset continues
to move up.
How can I make the offset find the employee data each time as well as
the jobcode and job title?

Each employee is listed like the above.

Please forgive the '''''''' it's the only way I can get the layout to
stay right

Thanks
Charles


--
mrdata
------------------------------------------------------------------------
mrdata's Profile: http://www.excelforum.com/member.php...o&userid=17899
View this thread: http://www.excelforum.com/showthread...hreadid=560096