View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
aileen aileen is offline
external usenet poster
 
Posts: 78
Default IF value = "DEC" or "MAR" cut and paste 3 cells

I need to search column B and if I find DEC, MAR, JUN, or SEP I need to cut
the cells from that row in column B, C and D and paste them in C, D and E.
e.g.

Column B C D E
PUT MAR 9 SP
CALL DEC 8 IND
DEC 8 SP 500
CALL JAN 9 IND
MAR 9 SP 500

After running macro, should line up as below:
Column B C D E
PUT MAR 9 SP
CALL DEC 8 IND
DEC 8 SP
CALL JAN 9 IND
MAR 9 SP

Any help is greatly appreciated. Thanks