How to copy data automatically from one workbook to another if condition met?

Hi,

I need a formula ( not vba code)

I am working on two different workbooks. In both workbooks I have 5 columns " Date" , " Customer Name" , "Invoice number", "Amount Received", "Amount Receivable".

My master workbook is workbook#1. I want when workbook#1 shows any balance in " Amount Receivable " . The whole data of that row should be automatically copy to workbook#2.

I don;t want VBA code..Just a formula.

Plz Help..

Kind Regards
Zaheer.