View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Geoff Baker Geoff Baker is offline
external usenet poster
 
Posts: 1
Default Add blank space automatically in a column

For example, In excel in cells A2 to A56 I've got words in them, I wanted to copy all the cells in column A to B in same order,but when the word "check" is encountered, a blank cell will be added below the cell with the word "check". How can I do this?Help...

EggHeadCafe - Software Developer Portal of Choice
Dr. Dotnetsky's Cool .NET Tips and Tricks #24
http://www.eggheadcafe.com/tutorials...-cool-net.aspx