Macro code to do multiple tasks such as deleting rows, inserting borders and page breaks

Hi,

I use excel the entire day and i'm looking for a code to complete a multiple tasks. Please, I would greatly it appreciate if anyone can help.
Book1.xlsx

I have here information that I've imported from another chart.
I would like to accomplish the following tasks using macros:

1) delete any rows that contain a "0" or nothing in column B automatically
2) right below the last row that contains information I would like to border two cells with a box as shown and fill the cells in the color yellow.
3) in that box I would like to have the left cell contain the text "total" and the right cell to auto-sum everything in column B.
4) and last but not least I would like to automatically have the page break (for printing purposes) to be right below the boxed cells and having peace of mind that every bit of information on the spreadsheet will be printed.

Thank you :-)

I tried it and it did the job for everything besides the pagebreak. I thank you for your work and efforts :-) but if you can please fix this one issue I would really appreaciate it.
Also, is it possible to make one border around those last cells instead of around each cell? I'm sorry i'm being finicky but this makes a difference to the spreadsheet we prepare at my workplace.
Thank you again for your efforts and looking forward to hearing from you again.

I tried the code and it did the job for everything besides the pagebreak. I thank you for your work and efforts :-) but if you can please fix this one issue I would really appreaciate it.
Also, is it possible to make one border around those last cells instead of around each cell? I'm sorry i'm being finicky but this makes a difference to the spreadsheet we prepare at my workplace.
Thank you again for your efforts and looking forward to hearing from you again.