It is possible, but can be rather complex.
To do it, you would put your data into sheet 4, then set the criteria
to paste to which ever sheet you want.
Once the criteria have been set, select the cells you want pasted to
the respective sheets, then search for the insertion point and insert.

It would have to be done in VBA because of the volitility of the data


--
bgeier
------------------------------------------------------------------------
bgeier's Profile: http://www.excelforum.com/member.php...o&userid=12822
View this thread: http://www.excelforum.com/showthread...hreadid=545981