Update existing spreadsheet macros

The current spreadsheet has several macros. Two things need to be completed. First, there is a copy and paste that takes place that moves data from the tab called "Master Bath" to the tab called "PO". That copy and paste needs to include a subtotal. Currently there is a line that has a total on there that sums everything up, but for some reason that line gets hidden before it gets transferred over and I can't figure out why. The other thing that needs to be done is when you run the macro and you select "Arizona Tile Taxable" in the "Bathroom Filters" window that pops up, the calculations that need to be completed need to use the "rounded" number column instead of regular number column. That is, use column AR instead of AP. This is ONLY when Arizona Tile Taxable is selected. To run the macro, start the macro called "ShowWorksheetTools", which can be done by clicking on the icon that looks like 3 yellow dots connected with lines with a small blue diamond shape in the middle. That icon is towards the top of the page. Or you can start it through the Developer tab. Then click on "Master Bath", then "One". Then click on Arizona Tile Taxable. The macro runs from there. I will send you a link to the file via dropbox. Thanks.