Formulas between 2 workbooks

[DOJ]

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.

 

[David Biddulph]

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.

 

[DOJ]

Thank you for responding. It is the actual formula that I am having problems
with.

How do I tell the spreadsheet to transfer the figure in Column 'J' to
another worksheet if column 'K' says 'Yes'.

I have tried various different formulas but none of the work and the help
files just do not give me any idea as to where I am going wrong.

Thank you