In the Charges Calculator, I have been able to count number of times a logo appears in each funeral home account from the Data worksheet and multiply it with corresponding Logo Charge from Charges worksheet. What I need is to generate a report in Report for Rob worksheet that takes the data from the Charges Calculator and, for all values greater than $0, lists in rows the funeral home name, their client number, publication their logos were in, and corresponding total from Charges Calculator. None of the calculated totals on Charges Calculator should be merged into two rows - each is individual. See "To Do" worksheet for example of report.
Solved by C. H. in 19 mins