ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   shift formulas to the next column (https://www.excelbanter.com/excel-programming/365192-shift-formulas-next-column.html)

bill gras

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


All times are GMT +1. The time now is 10:30 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com