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

=IF((F4-E4)=10,Amend()+F4-E4,F4-E4)

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

You can't have a function transfer information to another cell, it will
return it's info in the cell where it's located, you would need a formula(s)
in the cells where you want this information. Otherwise you would need VBA

Regards,

Peo Sjoblom

"Monty" wrote:

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

=IF((F4-E4)=10,Amend()+F4-E4,F4-E4)

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

VBA? What will i look for.

Thanks

"Peo Sjoblom" wrote:

You can't have a function transfer information to another cell, it will
return it's info in the cell where it's located, you would need a formula(s)
in the cells where you want this information. Otherwise you would need VBA

Regards,

Peo Sjoblom

"Monty" wrote:

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

=IF((F4-E4)=10,Amend()+F4-E4,F4-E4)

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