Fill Cells based on next and or previous cells

**jilaba** · 03-04-2009, 11:28 AM

A1:A9 has Text data and name "Heads" is defined for this range

B1, B2, B3 have dropdown lists referring "Heads" range.

If i select B1 or B2 or B3, the next and previous cells OR two previous cells OR two next cells should be filled with the sequence from "Heads".

ie. :

If i select "Labour" in B2 cell, then B1 & B3 should show "Cement" & "Misc" respectively.

A1 - Brick
A2 - Sand
A3 - Steel
A4 - Cement
A5 - Labour
A6 - Misc
A7 - Refreshments
A8 - Transportation
A9 - Electricity

Workout Sheet is attached.

**Shijesh Kumar** · 03-04-2009, 12:04 PM

Is this what you are looking for..Check the attachemtn

**jilaba** · 03-04-2009, 12:36 PM

Thanks for that, but possibly without using VB.

I prefer to get the solution without VB.

1. Is it possible to do without using VB?
2. When "Brick" is selected in B2 & when "Sand" is selected in B3, B1 becomes blank - In both cases, B1 should show "Electricity".
3. When Brick is selected in B3 & when "Elec" is selected in B2 "Runtime Error 1004"

I prefer to get the solution without VB.

Originally Posted by Shijesh Kumar

Is this what you are looking for..Check the attachemtn

**NBVC** · 03-04-2009, 12:39 PM

Not possible without VBA.. because the next time you pick from B1 or B3, the formula that we could provide would be overwritten with your selection and therefore be lost forever.

**jilaba** · 03-04-2009, 12:40 PM

Oh. Clear. Thanks.

Originally Posted by NBVC

Not possible without VBA.. because the next time you pick from B1 or B3, the formula that we could provide would be overwritten with your selection and therefore be lost forever.