Hello,
I need help with the following.

I have a master report of all company employees. Example of the report
is:
Reg Dist Store EE# Name
REG03 007 0034 12345 JOHN DOE
REG03 007 0035 12345 JOE DOE
REG03 007 0040 12345 JOY DOE
REG07 010 0407 54321 JANE DOE
REG09 059 0320 67890 JILL DOE
REG03 087 0542 9876 JACK DOE

What I would like to do is have something, Macro/VBA/anything identify
all like cells in Dist and transfer those cells onto a new worksheet.
So now I'll have a worksheet that has only information for 007, 010,
059, and 087. If anyone has any ideas, I'd be happy to hear them.


--
bhussey
------------------------------------------------------------------------
bhussey's Profile: http://www.excelforum.com/member.php...o&userid=31244
View this thread: http://www.excelforum.com/showthread...hreadid=509169