Macro fill cell cells with text from another column

Good day,

My next problem consists in making macro to fill only containing "blank" with value from another column. So if the cell (example D7) contains text "blank" it has to be replaced with text from E7...

For easier understanding find attached picture:

capture.jpg

Many thanks for help

Hi forfiett,

u need only for column D

Hi forfiett,

plz find the attached workbook and please have review and let me know is it meet ur requirement or not.

Hi forfielt,

If u satisfied with the solution then please mark this thread as solved.

Originally Posted by HaHoBe

Hi, forfiett,

could be done using Autofilter, filter on either item blank or empty cells, mark the range, enter Formula to next cell in highlighted cell, hit CTRL + ENTER to enter formula into all cells.

Any list should have a header and not start in Row1 (thatīs what I learned from Databases).

Ciao,
Holger

i know these option but my workbook is intended for a wast range of people with poor excel knowledge and it would be too hard to teach all of them.

now check it out i hv updated

Thanks for quick reply. I will check now and reply

I don't know what have you done but it is working
I will try different times and reply if any error occurs.

Many thanks for your help

Good, please mark this thread as solve don't forget.

steps to mark thread as solved

goto 1st post - click on thread tool option - then click on "Mark this thread as solved".

Marked as solved :D