You could but why not just have a macro that does use autofilter for each
group and auto copies to the separate sheets, overwriting the old info each
time..

--
Don Guillett
SalesAid Software

"TEAM" wrote in message
...

I need some help with a spreadsheet that is setup as follows...

"SummaryofChanges" Sheet - Contains data organized by column headings
and each row represents a unique person. Some values can be identical
between rows, but the Social Security Number is column A will always be
unique. Column B contains either "new hire", "existing employee", or
"terminated". All other columns contain data about the employee.

The remaining sheets in the workbook are labelled according to "new",
"existing", and "term".

"New" Sheet - should list employee records that show "new hire"

"Existing" Sheet - should list employee records that show "existing
employee"

"Term" Sheet - should list employee records that show "terminated"


I need help getting this information to auto-populate on each of these
sheets. Although autofilter would normally be used is not a reasonable
option because of additions, subtractions and general formating changes
that will be done to each employee record once the are move to each
sheet.

Is there a way to do this without autofilter?? THANK YOU!


--
TEAM
------------------------------------------------------------------------
TEAM's Profile:
http://www.excelforum.com/member.php...o&userid=22810
View this thread: http://www.excelforum.com/showthread...hreadid=541860