Filling in empty cells in columns

[koba]

Dear All

I have a problem could somebody please help?

I have 3 columns of data A,B,C. A nd B are full but not all the cells in C are filled out. How do I make the cells in C that are empty equal the value in B without having to do it manually and still keeping the existing values in C?

Please help

Much Appreciated

Andrew

PS Thank you to whoever helped me last time I didn’t get a chance to say that.

[bpeltzer]

Select your entire data set and turn on autofilters: Data > Filter >
Autofilter. Use the drop-down in column C to select blanks. In the first
row remaining visible, enter the formula to copy the value from column B (ex:
if it's row 39, then in C39 you'd enter =B39). Autofill the formula down
through all the visible rows.

"koba" wrote:

>
> Dear All
>
> I have a problem could somebody please help?
>
> I have 3 columns of data A,B,C. A nd B are full but not all the cells
> in C are filled out. How do I make the cells in C that are empty equal
> the value in B without having to do it manually and still keeping the
> existing values in C?
>
> Please help
>
> Much Appreciated
>
> Andrew
>
> PS Thank you to whoever helped me last time I didn’t get a chance to
> say that.
>
>
> --
> koba
> ------------------------------------------------------------------------
> koba's Profile: http://www.excelforum.com/member.php...o&userid=28639
> View this thread: http://www.excelforum.com/showthread...hreadid=483280
>
>

[koba]

Thanks heaps worked a treat!!!

Andrew