need help on pasting link if certain cells blank

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.

The formulas appear syntactically correct.

--
Regards,
Tom Ogilvy


"glennmasters@hotmail.com" 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.
>
>