MrExcel Publishing
Your One Stop for Excel Tips & Solutions

filling cells


Posted by Aysegul on December 10, 2001 7:12 AM

I have Column A which has missing data in some cells, I want to fill missing cell with the value of preceding cell . For example A1 has a value but A2 and A3 are missing, A4 has a value but A5 and A6 missing so I want to fill A2 and A3 with value of A1, and A5 and A6 with value of A4 and so on. What will be the macro for this?
Thanks for the help


Posted by Mark W. on December 10, 2001 7:43 AM

See...

Posted by Aysegul on December 10, 2001 9:19 AM

Re: See...

That formula is not very efficient for me.Because my problem is slightly different. But thanks anyway.

Posted by Mark W. on December 10, 2001 10:15 AM

Re: See...

> ...my problem is slightly different

The instructions that I gave you will work
quite well for the example that you included
in your posting.

Posted by Aysegul on December 10, 2001 10:27 AM

Thanks

Thanks
It was my mistake, you are right it works very nicely.
Aysegul