Hi,
you will need to ascertain what the common value is to
identify. For example: if any cell in column A has "YES"
then copy that entire row(?) and paste it ot a new sheet.
If you cannot get any help here, could you send some
sample data and the value to find, to me, and I will
create something.
See my stuff at:
http://www.geocities.com/excelmarksway



- -Mark

-----Original Message-----
I have a spreadsheet with 25,000 rows of data. I need to
copy all
rows which have the same value in colum A to a new
sheet. Is there
any way to do this automaticaally. Assume there are 50-
60 different
sheets that need to be created. As a second condition
could I have
this rename the name of the sheet to match the value in
Column A?
Thanks
.