You say "JobName, Job$M, Job$A, PriorC% are brought in from another sheet
based on Job#" Do you need for the code to do this? If so, what is the
name and layout of that other sheet?
You say "I want the Date, Job#, JobName, %Comp Job$M to copy over to
different sheets based on the initials entered in G". Are these "other
sheets" named those initials? In other words, if there is "AB" entered in
Column G, is there a sheet named "AB"? What is the layout of these
"different sheets"? In other words, where in these "different sheets" do
you want the data pasted?
The same questions for copying based on the entries in Column H. Otto




"Bcosta" wrote in message
...

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.