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

--
Regards Ron de Bruin
http://www.rondebruin.nl


"bonzai18" <[email protected]> wrote in message
news:[email protected]...
>
> 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
>

[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)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

"bonzai18" <[email protected]> wrote in
message news:[email protected]...
>
> 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.