Help with functions

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?
> >
> >