Columns a
A B C D E F G H I
J
Date Job# JobName Job$M Job$A PriorC% Mech Appr 3rdMan %Comp

Where Date is entered, Job # is entered
JobName, Job$M, Job$A, PriorC% are brought in from another sheet based on Job#
Mech, Appr, 3rdMan and %Comp are entered

I want the Date, Job#, JobName, %Comp Job$M to copy over to different sheets
based on the initials entered in G

I want the Date, Job#, JobName, %Comp Job$A to copy over to different sheets
based on the initials entered in H

I need to have the data left intact in the original sheets so COPY is a
better word than EXTRACT i suppose.

"Otto Moehrbach" wrote:

You will need VBA (programming) for this.
Are the "other sheets" named the initials in column G of that first sheet?
What is the name of the first sheet? What is the layout of your data, i.e.,
how many columns to copy, what columns, starting with what row in that first
sheet, starting with what row in those "other" sheets? HTH Otto
"Bcosta" wrote in message
...
I have a sheet in a workbook that I want to extract information from based
on
Initials in Column G and have the information placed into other sheets in
the
workbook based on the initials. I need to have the data in date order
(Column
A) and no blank lines. I'm at a complete loss as to how to do this.