Thread: Give blank in cell
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
bbc1 bbc1 is offline
external usenet poster
  
Posts: 12
Default Give blank in cell
I have 10 cells in column A
A1
A2
A3
A4
A5
etc
What I require is if cell A1 is blank then blank in all cells, if A1 is one
then add one to each cell
ie if A1 =1 A2 =2

Reply With QuoteReply With Quote