View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
bill gras bill gras is offline
external usenet poster
 
Posts: 48
Default shift formulas to the next column

Hi

I have text in column F and formulas in columns G,H,I,J,K, Every so many
rows
at random there is a empty cell in column F . When a cell is empty in
column F
I need the formula from the cell in the same row in column L shifted to
column M
in the same row and later to be shifted back from column M to L (column M
is an empty column )
I need to run the macro my self so I can shift left to right and back at my
own will
with a key funtion . There are 1500 rows
I'm no good with macro's , if some one can help me could you , please ,
please explain to me how to set it up

Thanking you all in advance
--
bill gras