mfisher316
New Member
- Joined
- Mar 8, 2007
- Messages
- 7
Here's what I need to do:
I have data in multiple rows and 12 columns. When a cell in column B is blank, I need to insert a row at the row below the blank cell. In the inserted row, I need to insert a formula in column c. (formula is done)
Also, when the cells in columns K&L are > 0, I need to cut the cell in column K and paste to same row in column G. I need to cut the cell in column L and paste to same row in column J.
Another thing, we put data in at different times and I don't want to keep running on the same data. (i.e. I only want it to run on data when there are values in columns K&L).
I have a macro that works in Lotus 123 and I need to get it to work in excel (or else I am doomed to continue working in Lotus!).
Please help.
I have data in multiple rows and 12 columns. When a cell in column B is blank, I need to insert a row at the row below the blank cell. In the inserted row, I need to insert a formula in column c. (formula is done)
Also, when the cells in columns K&L are > 0, I need to cut the cell in column K and paste to same row in column G. I need to cut the cell in column L and paste to same row in column J.
Another thing, we put data in at different times and I don't want to keep running on the same data. (i.e. I only want it to run on data when there are values in columns K&L).
I have a macro that works in Lotus 123 and I need to get it to work in excel (or else I am doomed to continue working in Lotus!).
Please help.