need help on pasting link if certain cells blank

G

glennmasters

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need Help with a VBA subroutine 0
loop to copy paste 5
Can I send an email too? 3
copy/paste in the next column 4
Need some help constructing a Do While statement 2
help with syntax for copy and pasting rows across sheets 4
Create if partial match then copy and paste data from one cell to another 1
Copy/Paste Template to New Workbook 11

Top