I make this kind of string formula:
="=IF($C14=$CC$5;"&"$CC$5;IFERROR("&"VLOOKUP($C14;"&"'"&REPLACE(CELL("filename");FIND("[";CELL("filename");1);(FIND("]";CELL("filename");1)+1-FIND("[";CELL("filename");1));'SETING AWAL PERIODE'!$Y$10)&"'!"&"$C$15:$CU$215;"&"'"&REPLACE(CELL("filename");FIND("[";CELL("filename");1);(FIND("]";CELL("filename");1)+1-FIND("[";CELL("filename");1));'SETING AWAL PERIODE'!$Y$10)&"'!"&"CM$14;FALSE);$CC$5))"
Then copy Value to another Cell, it become a kind of active Formula:
=IF($C14=$CC$5;$CC$5;IFERROR(VLOOKUP($C14;'D:\YOVAN\INDUSTRI\MONTHLY SALARY\[SalaryNopember2014.xlsm]ABSENSI'!$C$15:$CU$215;'D:\YOVAN\INDUSTRI\MONTHLY SALARY\[SalaryNopember2014.xlsm]ABSENSI'!CM$14;FALSE);$CC$5))
The problem is this formula only active after pressing F2 and Enter
Please help me how to make this formula automatically active without pressing F2 and Enter
And the code in VBA if still need using F2 Enter.
Thanks For any helping hands
Bookmarks