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