How do I transfer certain cells only if a certain range has a value over 0?

[Marissa F]

I am trying to complete a business pricing sheet. I already have it where once I type the quanity, it calulates based on the price ranges in the cells to the left. Now I want to take those values, and transfer it to another sheet which will turn into a formal estimate that gets downloaded and sent out to the clients. I only want data from the totals column that has values to trasnfer. So for example in the picture below, if no "Grass Removal" or "Wire" is being performed, their totals are "0" and I don't want them to transfer to the estimate sheet. I would only want the services that are being performed transfer to the next sheet for the estimate. PLEASE HELP!

 

[James006]

Hi,
Take a look at following detailed explanation :

How to Autofilter and Copy Visible Rows with Excel VBA - ExcelDemy

n this tutorial, I’ll demonstrate 3 methods to autofilter and then copy the filtered visible rows in Excel VBA with proper explanation.

www.exceldemy.com