Why not just take that data and copy|paste special|values to a different
sheet?

Dave, yes that would be acceptable - this is actually what I meant by
"(or equivalent)". Looks like I may have been trying to take a
sledgehammer to a walnut? :)

I don't care how I get it done, as long as I get a copy of what is
displayed on my worksheet each time a trade is placed - but I need it
to be automated.

Thanks for your reply,

Barry


--
Barry Taylor
------------------------------------------------------------------------
Barry Taylor's Profile: http://www.excelforum.com/member.php...o&userid=20541
View this thread: http://www.excelforum.com/showthread...hreadid=520027