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.