Hi Bull,
I see you incorporated the Week #. Could you see the option of putting the latest Week on the top.
Next, before the Weeknum, in the formula, there is a link coming, like
=IF(B20>0,RIGHT(YEAR(B20),2)&" Week "&'C:\Program Files\Microsoft Office 2003\OFFICE11\LIBRARY\Análisis\ATPVBAEN.XLA'!WEEKNUM(B20),"")
Thanks,
Fx4gain
I see you incorporated the Week #. Could you see the option of putting the latest Week on the top.
Next, before the Weeknum, in the formula, there is a link coming, like
=IF(B20>0,RIGHT(YEAR(B20),2)&" Week "&'C:\Program Files\Microsoft Office 2003\OFFICE11\LIBRARY\Análisis\ATPVBAEN.XLA'!WEEKNUM(B20),"")
Thanks,
Fx4gain