Hi

Rather than copying the data out to another sheet, why not just use Autofilter?
Mark the column headings.
DataFilterAutofilteruse the dropdown on Employees Name to bring up a list
of just his/her work orders.

Regards

Roger Govier


cdixon wrote:
I need help in creating an automatic record form a file to an individual
record.
Example: You would make a work order for three different employees the
first employees work order enter name, date, location, time, cost, and
then this information would automatically be recorded to a permanent
work sheet record specific to that employee. I have tried to manipulate
VLOOKUP for this but to no avail.
Any clue or help would be greatly appreciated.