Hiya,
A bit general I know, but is it possible to write an IF statement to updates another workbook?
Thanks
Louise
Hiya,
A bit general I know, but is it possible to write an IF statement to updates another workbook?
Thanks
Louise
Last edited by LouiseH24; 03-07-2012 at 11:13 AM.
The IF statement would have to BE in the other workbook.
A VBA approach would be another way
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
Yes, the "if" statement would pull values from another workbook and update the workbook that it is written in.
Example: =IF(ISBLANK('INSERT FILE PATH HERE'!$J$8), "No", "Yes")
This one checks to see if the cell in the other workbook is blank and returns values Yes or No in the cell that the "if" statement is written in (J8 in this case).
Thanks guys - some great solutions
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks