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.

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.

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

"DOJ" wrote:

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.

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.
--
David Biddulph

"DOJ" wrote in message
...
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

"DOJ" wrote:

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.