Populate cell IF another cell is blank
 

I've got a sheet that has special product assemblies that consist of a
"parent" product description, and a listing of components that the "parent"
product consists of.

What I need to be able to do is have the parent qty overwrite the component
qty. Right now if the line contains a component column B is empty.

Logically I see (but am not sure how to do), IF column B is "" THEN replace
column A value with value in preceeding line A column value.
=IF(B2="",A1,B1) Need to do this with a macro.

Thanks in advance!


Example below.

What I have now:
Col A Col B Col C
4 Parent
1 Component
1 Component
3 Parent
1 Component

What I want to end up with:
Col A Col B Col C
4 Parent
4 Component
4 Component
3 Parent
3 Component

Populate cell IF another cell is blank
 

What I have now: =IF(C3="",A3,D2)
Col A Col B Col C Col D
4 Parent 4
1 Component 4
1 Component 4
3 Parent 3
1 Component 3


"Scott Wagner" wrote:

I've got a sheet that has special product assemblies that consist of a
"parent" product description, and a listing of components that the "parent"
product consists of.

What I need to be able to do is have the parent qty overwrite the component
qty. Right now if the line contains a component column B is empty.

Logically I see (but am not sure how to do), IF column B is "" THEN replace
column A value with value in preceeding line A column value.
=IF(B2="",A1,B1) Need to do this with a macro.

Thanks in advance!


Example below.

What I have now:
Col A Col B Col C
4 Parent
1 Component
1 Component
3 Parent
1 Component

What I want to end up with:
Col A Col B Col C
4 Parent
4 Component
4 Component
3 Parent
3 Component

Populate cell IF another cell is blank
 

Actually need to do this with a macro, but thanks anyway.



"wana be xl master" wrote:

What I have now: =IF(C3="",A3,D2)
Col A Col B Col C Col D
4 Parent 4
1 Component 4
1 Component 4
3 Parent 3
1 Component 3


"Scott Wagner" wrote:

I've got a sheet that has special product assemblies that consist of a
"parent" product description, and a listing of components that the "parent"
product consists of.

What I need to be able to do is have the parent qty overwrite the component
qty. Right now if the line contains a component column B is empty.

Logically I see (but am not sure how to do), IF column B is "" THEN replace
column A value with value in preceeding line A column value.
=IF(B2="",A1,B1) Need to do this with a macro.

Thanks in advance!


Example below.

What I have now:
Col A Col B Col C
4 Parent
1 Component
1 Component
3 Parent
1 Component

What I want to end up with:
Col A Col B Col C
4 Parent
4 Component
4 Component
3 Parent
3 Component