View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Rob Rob is offline
external usenet poster
 
Posts: 234
Default 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