Multiple sheets and Data

[mcommon1]

Gurus,

Ok, I (using asap utilities) took my 600 line 50 or so unique rows (all with 75 columns of unique data in them) and created worksheets for each unique instance (but it copied All data in each sheet).

Anyone know how I can automatically take the 50 sheets now created and in each sheet delete all lines that do NOT have the sheet name in collumn A (for example)?

Thanks!

Mark