Formulas between 2 workbooks

D

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.
 
D

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.
 
D

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
 
D

David Biddulph

It looks as if you've replied to your own message, rather than to whichever
message you intended to reply.

Your formula will look something like
=IF([Bookname.xls]Sheetname!$K$1="Yes",[Bookname.xls]Sheetname!$J$1,"value
if condition not met")
and you've been told how to put the references into your formula.
 
Top