| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Rephrased - Remove blank cells - no sorting, copy or pasting | Excel Worksheet Functions | |||
| putting a (.) period in blank cells when pasting data | Excel Worksheet Functions | |||
| Pasting on Filtered Data Sheets without pasting onto hidden cells | Excel Discussion (Misc queries) | |||
| how eliminate zeros in blank cells using paste link | Excel Worksheet Functions | |||
| Copying and pasting a worksheet to a blank and removing blank rows | Excel Programming | |||
Linear Mode
