The formulas appear syntactically correct.

--
Regards,
Tom Ogilvy

" wrote:

I have the following formula that copy and pastes if there in data in
cells af2 or bl2.

=if(or(sheet1!AF2="", sheet1!BL2=""), "", sheet1!C2)

Im trying to amend it so it uses different columns.

Im using sheet no 2 get the data from and sheet no 4 to paste to. I
have the following but when i input all the data including data in
either rows af or bl it wont let me do it.

This is wot ive got. can someone confirm its correct.

=IF(OR(Sheet2!AF4="", Sheet2!BL4=""), "", Sheet2!c4)

=IF(OR(Sheet2!AF4="", Sheet2!BL4=""), "", Sheet2!D4)

=IF(OR(Sheet2!AF4="", Sheet2!BL4=""), "", Sheet2!E4)

=IF(OR(Sheet2!AF4="", Sheet2!BL4=""), "", Sheet2!AF4)

=IF(OR(Sheet2!AF4="", Sheet2!BL4=""), "", Sheet2!bl4)

Donno if it makes any difference im actually starting it in row no 1
rather than 2 in the workbook im copying to.

Ive started with no4 in sheet 2 as thats the first line I wanna get the
data from.