Try this
http://www.rondebruin.nl/copy5.htm

--
Regards Ron de Bruin
http://www.rondebruin.nl


"Jenn" wrote in message ...
Hi.
Is there a way to copy specific rows from 1 sheet to another?
For instance I have a workbook containing 4 tabs. These are labeled "raw
data", "Sheet A"," Sheet B", and "Sheet C". On the "raw data" sheet there
are 3 columns. One of the columns is titled "Project". In there the values
are A, B, C or D (and maybe E someday). I would like to say "if the
"Project" column contains and "A" copy everything on that row to "sheet A".
Basically I want to take all t he information that has a project A value and
copy it to sheet A, all the data that has a prokject B value and copy it to
sheet B, and so on. Is this possible?

Thanks in advance.