If I have the following formula in a worksheet to bring up a message box

=IF((F4-E4)=15,PromptPayment()+F4-E4,F4-E4)

How can I transfer some information from different cells to a new worksheet
if the formula above works?

Thanks

Monty