You've also got a response to play with (using non-array formulas)
in your multi-posts (urgh ..) in .newusers (& .worksheet.functions)

See: http://tinyurl.com/gpoh6

(Pl refrain from multi-posting)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

"bonzai18" wrote in
message ...

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.