I have a requirement to copy employees based on their
names from one worksheet to other worksheets. The criteria
would be to find their matching names and copy the
adjacent rows of information as well. The new worksheet
should be populted based on the date entry. Since there
are more than 20 employees listed in a random order there
should be a sorting by date and entering to the new
worksheet in the same order.

Anyone having a solution via VB or macro would be
appreciated.

Explore use of the advanced filter. (data=Filter=Advanced Filter)

You can put your list of names in the criteria (in a single column) and
choose to have the data copied to another location. Since you want to go to
another sheet, you need to start from the destination sheet. Once you get
the data to the sheet you can sort it by date

You can turn on the macro recorder while you do this manually to get the
code.

--
Regards,
Tom Ogilvy


"Vick" wrote in message
...
I have a requirement to copy employees based on their
names from one worksheet to other worksheets. The criteria
would be to find their matching names and copy the
adjacent rows of information as well. The new worksheet
should be populted based on the date entry. Since there
are more than 20 employees listed in a random order there
should be a sorting by date and entering to the new
worksheet in the same order.

Anyone having a solution via VB or macro would be
appreciated.