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. |
need help on pasting link if certain cells blank
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. |
All times are GMT +1. The time now is 08:36 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com