Using Excel 2010, I have 2 workbooks with multiple worksheets and have tried to use an IF formula to copy data from a cell in one worksheet from one file to a cell in a worksheet in a different file. I do not want data copied from blank cells.
Specifically, I want to copy the value in workbook 1, cell G16 to the 2nd workbook called budget new, worksheet February, cell G127.
In workbook 1, this is the formula: =IF(G16>0,[budget_new.xlsx]February!+G127,""). The error shows an invalid entry [budget_new.xlsx]February!+G127, for [value_if_true].
Thanks for your help.
Bookmarks