Move two cells up if condition met

[Krzys]

I have just one question. What would be the best code for below situation?
If 5 first columns are empty and column, F & I have number DO: move numerical value of cell F & I one row up. It might be over 2000 rows of data.
Thanks Krzys

[davesexcel]

I have just one question. What would be the best code for below situation?
If 5 first columns are empty and column, F & I have number DO: move numerical value of cell F & I one row up. It might be over 2000 rows of data.
Thanks Krzys

Sorry, this just doesn't seem logical, why would you do this??
I am not saying it can't be done but why would it be required??

[Krzys]

Hi Dave, Thanks for asking
Of course, it makes sense to me. I convert text file into excel and when it is done some rows are not lining up. I have to convert text to excel with fixed width. It is accounting file. Sometimes when description of posting is long, DR. and balance are not in the some row where date and descriptions are. To illustrate:
Example is as attachment
I want 150.00 and 250.00 one row up. I know I will lose some letters of description like “ion” in this example. I hope it makes it easier to understand.

[davesexcel]

Hi Krzys,

here is some code and an example workbook

Please Login or Register  to view this content.

[Krzys]

Dear Dave it is great what you wrote. I attached real live example. What I wnanted to achieve is move all yellow higlited cells one row up.
Then I have code to delete empty rows. When I run your macro on excel 97 (at home) I have message variable not defined and highlited word Last Row (in line 3) also I tried to alter some cells but the same error.
I don't want to be anoying but could you kindly look on my example.

[Krzys]

Dave I got it.

Please Login or Register  to view this content.