I have a workbook with invoice data. There is a column called amount outstanding. When that column says $0.00, I want specific data from that line to fill in (spill over) to my 2nd workbook.
Example - Workbook 1 called Kyle Sales and Bid Log
On tab Sales Log 2025, when column AO says $0.00, I want that line to then feed into 2nd spreadsheet - called Marlyn 2025 Summary. There are only certain items I want brought over from the Sales and bid Log. I would like for the cells to remain empty until the column in workbook 1 is $0.00.
I thought I had the formula correct but it returned the word FALSE in every cell or it would return data, even if column AO didn't say $0.00.
Pictures are below I'd appreciate any help I can get!
Example - Workbook 1 called Kyle Sales and Bid Log
On tab Sales Log 2025, when column AO says $0.00, I want that line to then feed into 2nd spreadsheet - called Marlyn 2025 Summary. There are only certain items I want brought over from the Sales and bid Log. I would like for the cells to remain empty until the column in workbook 1 is $0.00.
I thought I had the formula correct but it returned the word FALSE in every cell or it would return data, even if column AO didn't say $0.00.
Pictures are below I'd appreciate any help I can get!