Populate cell IF another cell is blank

G

Guest

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
 
G

Guest

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

Conclude new account number 1
A For Each in Range... with a .Find(what:="TJ", ... in it problem 15
Column number of last column that returns value ignore formulas 8
VBA If Statement 2
move data w/o blank data to another sheet 1
Loop thru xx No. of sheets until the four strValue combo's are found 6
Maximum value as well as Sum 1
Urgent help with input box & loop 1

Top