Yes, but remember that a formula "pulls" data into the cell whether the
formula resides, rather than "pushes" data elsewhere.

Put your formula in the destination cell in the destination workbook,
starting with the = sign, and you can include in the formula the refeernces
to the source cells in the source workbook by clicking in the relevant cells
while you are editing the formula.
--
David Biddulph

"DOJ" wrote in message
...
Hello

I hope I explain this ok.

I want to be able to transfer the figure in column 'J' to another workbook
as long as 'Yes' has been entered in column 'K'. Can this be done? I
have
read through the various help files but cannot seem to see anothing that
may
help.

Any help would be greatly appreciated.