Do you want them to move as you enter them, or move them after all are
entered?
Are the names in column 1 always the same, or will they be different?
If the names are always the same, you can create the sheets in advance,
then sort the data on "Sheet1", then cut/paste them to the sheet.
If the names change each time, you could sort by column "A" then create
a sheet for each name, then copy/paste.


You could do it with with either by formulae or by VBA. I suspect VBA
would be the easiest.


--
bgeier
------------------------------------------------------------------------
bgeier's Profile: http://www.excelforum.com/member.php...o&userid=12822
View this thread: http://www.excelforum.com/showthread...hreadid=541607