Here is my problem: I have created a workbook to manage rental property, i have multiple sheets each pertaining to a different property (housing, apt complex, strip mall, etc.) on each sheet i have a column that contains amount due for the address. What i would like to do on a new sheet called rent due report is scan the amount due column for an amount over 0$ and return the address and amount due, but have no spaces between the results.
I have tried the "=if(B5>0,A5 & "" & B5,"") but this gives me blank cells between results. I would like to do this in vba since i believe it would be easier but a formula or array would work as well.
Any help would be appreciated
I have tried the "=if(B5>0,A5 & "" & B5,"") but this gives me blank cells between results. I would like to do this in vba since i believe it would be easier but a formula or array would work as well.
Any help would be appreciated