You could use formulas in teh respective sheet to extract the data.


You could write a macro that breaks out the information

--
Regards,
Tom Ogilvy


"Patrece" wrote in message
...
i was wondering, is it possible to have data be imported
into excel sheet 1 automatically sort into different
sheets by the information given.

i.e:
imports into sheet 1:
name id# contract#
alicia stevens 403 174309
greg johnson 721 309581
alicia stevens 403 290385
david micheal 124 093480

sheet 2 (aka stevens)
name id# contract#
alicia stevens 403 174309
alicia stevens 403 290385

sheet 3 (aka johnson)
name id# contract#
greg johnson 721 309581

sheet 4 (aka micheal)
name id# contract#
david micheal 124 093480


so is there some type of way to have the info from sheet
one automatically sort into their individual sheets as
soon as its dumped into excel? thanks in advance!