If value in cell make adjacent blank
This makes no sense to me - could you re-phrase?
Pete
On Oct 31, 10:10 am, whatzzup
wrote:
Good day, how to make all cells to left blank if a value is entered in a
cell, therefore i want bto select from dropdown asset pipeline and all left
cell row 2 be unable to be populated
a b c d e
Proj Asset Phase Wk Package Component
1 Rock
2 Pipeline
3 1
4 procure
5 Rig
6 2
3
b 2
3
4
|