i don't now it is possible
i have the followinf formula on the worksheet feestdagen
=ALS(E4="";"";DATUM(Kalender!$A$2;VERT.ZOEKEN(C4;$I$3:$J$14;2;0);D4))
it's a if then formula wit a verical search.
Is it posible to make a variable so that when i make a copy of the worksheet kalender and give it the name 2013.
So when he the work sheet 2013 is active the formula must be lik dis
=ALS(E4="";"";DATUM(2013!$A$2;VERT.ZOEKEN(C4;$I$3:$J$14;2;0);D4))
Or can i put he request value on the not active sheet feestdagen.
Bookmarks