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.