February 28, 2015 at 12:58 PM #1 Have this code that gets data from another workbook,can I add to code so if A1>0 paste the data in C1. so it gets data from one workbook and if the cell isgreater that 0 in paste in the other cell.If its a 0 then it does not paste. Code ='C:\Users\tom\Dropbox\[Master.xlsm]Address Book'!$A:$A
February 28, 2015 at 3:26 PM #2 Re: Possible to add IF to codeThis is a duplicate post and as such does not comply with our forum rules. This thread will now be closed, you may continue in your other thread. Thread Closed.