Hi,

I need help with the project below. I wanted to move only the date in
to the Column A and if the data in the second column is empty then use
the date from previous cell. For example, B14 is empty so I want to
use the date which is in the cell B10. I have about 40,000 records
like this I need some easy fix to do this.

Please if anyone could help me with if there is some kind formula to
generate the output as I have it below.

Any help can be appreciated.

Thanks all


+-------------------------------------------------------------------+
|Filename: Matrix.zip |
|Download: http://www.excelforum.com/attachment.php?postid=4300 |
+-------------------------------------------------------------------+

--
xgunda420x
------------------------------------------------------------------------
xgunda420x's Profile: http://www.excelforum.com/member.php...o&userid=25559
View this thread: http://www.excelforum.com/showthread...hreadid=507335