Thank you very much for your help and the code. Works perfectly.
I can see how the columns are calculated in the export page - ver
impressive.

I am perhaps asking the impossible here but here goes...

I see in your formula you are looking for an output in each chang
within column A,
is there anyway you can say in the VBA that you only want to repor
each change in column A when, for example column B is 1/12/2003 ?

Many thanks again,

Scott

--
scottwilson
-----------------------------------------------------------------------
scottwilsonx's Profile: http://www.excelforum.com/member.php...fo&userid=1112
View this thread: http://www.excelforum.com/showthread.php?threadid=26382