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

I got an invalid attachment error when I tried to look at the file.
Will you please post a sample of your data, showing "before" and
"after"?

Also, please explain your subject line, "Excel project for credit".
Happy to show you how to do something, but few people on this Google
forum will do your homework for you!

Hi Thanks for quick respond.

I was able to open the zip file. I attached JPEG image in the zip
file.

Hope it works dis time.

thanks


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