Yes this can be done.

The format of the data will determine the complexity of the code to
move the data between sheets.

If the data has some specific/unique identifier separating the data, it
should be relatively easy. If not, it can be a veritable nightmare.

If you could be a little more specific, like showing some sample data,
or the data format, it would be a big help and would make answering
your query a lot easier.


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