![]() |
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