I'm not sure how to explain this, but here we go.

I have a workbook w/ multiple worksheets. The first worksheet is
titled ALL. This includes all information from other worksheets. How
can I have certain information transfer to other worksheets by
recognizing initials?

Basically if the "All" worksheet has has an S listed it - can I
transfer to worksheet titled Scott w/o the beating of copy and paste?

Thanks in advance.


--
bonzai18
------------------------------------------------------------------------
bonzai18's Profile: http://www.excelforum.com/member.php...o&userid=32448
View this thread: http://www.excelforum.com/showthread...hreadid=522233