How do I get data to display in second excel sheet when another is changed?

I have an excel template with many different sheets in it. Sheet A has a column for Pending cost and a column for Reconciled cost. Sheet B has a column for Amount and a column for transaction date. Is there a way to have the amount that is entered in sheet B to display in sheet A under pending, but when a transaction date is entered the amount deletes from pending and then displays in reconciled cost?|||Sheet A 鈫?Heading 鈫?A1 Pending Cost 鈫?Heading 鈫?B1 鈫?Reconciled Cost



Sheet B 鈫?A1 鈫?Heading 鈫?Transaction Date 鈫?Heading 鈫?B1 鈫?Amount



Formula Sheet A 鈫?

A2 鈫?=IF(SheetB!A2%26gt;0,0,SheetB!B2)

Drag Range

B2 鈫?=IF(SheetB!A2%26gt;0,SheetB!B2,0)

Drag Range



脮脮

么

~