Hmmm

[bonzai18]

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.

 

[Ron de Bruin]

Hi bonzai18

Start here
http://www.rondebruin.nl/copy5.htm

 

[bonzai18]

Thank you.

 

[Max]

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)