Populate cell IF another cell is blank

S

Scott Wagner

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
 
W

wana be xl master

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top