View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default 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