Week vs. Week VBA Function
Hi,
I regularly need to show a percentage difference between sales of this week
versus last week and use one or the other formula below; what would be nice
is to have a custom Function that allowed just the last week and this week
cells to be entered eg. =LWDIF(B2, A2). It would also help if like in Excel
a prompt was shown when entering the formula eg. LWDIF(thisweek, lastweek)
and I was allowed to use the keyboard arrows to navigate to the relevant
cells.
90 100 =(B1-A1)/A1
90 100 =(B2/A2)-1
Any help would be most welcomed.
Thanks in advance, Rob
|