Hi,
I have cell C12 with a drop down list which are 1 & 2,3 & 4,5 & 6. I need that:
1. When I choose 1 & 2 from the drop down, cell E17 appears as METER 1 and cell H17 appears as METER 2.
2. When I choose 3 & 4 from the drop down, cell E17 appears as METER 3 and cell H17 appears as METER 4.
3. When I choose 5 & 6 from the drop down, cell E17 appears as METER 5 and cell H17 appears as METER 6.
Any help is appreciated.
I have cell C12 with a drop down list which are 1 & 2,3 & 4,5 & 6. I need that:
1. When I choose 1 & 2 from the drop down, cell E17 appears as METER 1 and cell H17 appears as METER 2.
2. When I choose 3 & 4 from the drop down, cell E17 appears as METER 3 and cell H17 appears as METER 4.
3. When I choose 5 & 6 from the drop down, cell E17 appears as METER 5 and cell H17 appears as METER 6.
Any help is appreciated.