Excel project for credit

[xgunda420x]

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

[Dave O]

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!

[xgunda420x]

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