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

Similar Threads

Extracting a cell value 2
Conclude new account number 2
A For Each in Range... with a .Find(what:="TJ", ... in it problem 15
Loop thru xx No. of sheets until the four strValue combo's are found 6
Nested IF conditions 3
Counting unique values in multiple columns 4
VBA to Find Key Words in Word doc then Extract Content to Excel.xlsm file 3
Copy Application.Union(c.Offset(0, 1), c.Offset(0, 2)... to a list onsame & another sheet 27

Top