VBA that deletes rows in 12 columns if there is no entry

[matthewdete]

Hello, I am trying to build a macro and I sincerely wish I could do it myself to perform a few functions before uploading an export into JDE.

1. - I have to delete all rows that are filled with zeros across 12 columns.
2. - I have to total columns across a range, which in this case is 12 columns.
3. - I would like to would like to also round the first 11 columns and place the difference in column 12.
4. I also have the need to reverse the value in revenue accounts and other account that might be specified.

I have attached the spreadsheet that I am working with to give you a better feel. I can also give you an example of a desired result.

[stnkynts]

Would you please upload your workbook in excel format (rather than zip). Shouldn't be too hard to do what you are asking.

[matthewdete]

it was too large to upload.

[JOHN H. DAVIS]

Does this help?

Please Login or Register  to view this content.

[stnkynts]

Nevermind. Look like John's got it.

[matthewdete]

I am not even sure that I know how to run it. I will give it a try.

[JOHN H. DAVIS]

My attempt only deals with your first two issues.