| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to populate a cell with numeric value based on textselected from pull down in adjacent cell? | Excel Worksheet Functions | |||
| Populate a cell if values in cell 1 and cell 2 match cell 3 and 4 | Excel Worksheet Functions | |||
| check to see if a cell is blank if not populate adjacent cell wit. | Excel Discussion (Misc queries) | |||
| auto populate cell based on previous cell drop down list selectio. | Excel Discussion (Misc queries) | |||
| Want to be able to click on a cell and have a list box appear to give values to populate a cell | Excel Programming | |||
Hybrid Mode
