tlchan
07-26-2008, 07:37 PM
Hi there,
I have to prepare monthly sales performance review report showing monhtly data from Jan to Dec across the row for eah product. However I need to recalculate manually the proportionate budget sales from yearly target for specific month in order show the level of achievement in last column for the reporting month.
Format of the report as below:
Performance Report for July 2008
***************************
Product Jan Feb Mar Apr May Jun Jul Aug Sep Cul Prop Yrly
total target target
Produt A 45 63 75 85 90 120 T Y XX
The level of achievement in last column = Y/T X 100
Is there any function or VBA to automate the value Y correspond with month (in red) based on value XX for the corresponding month.
:bug:
Thank you
I have to prepare monthly sales performance review report showing monhtly data from Jan to Dec across the row for eah product. However I need to recalculate manually the proportionate budget sales from yearly target for specific month in order show the level of achievement in last column for the reporting month.
Format of the report as below:
Performance Report for July 2008
***************************
Product Jan Feb Mar Apr May Jun Jul Aug Sep Cul Prop Yrly
total target target
Produt A 45 63 75 85 90 120 T Y XX
The level of achievement in last column = Y/T X 100
Is there any function or VBA to automate the value Y correspond with month (in red) based on value XX for the corresponding month.
:bug:
Thank you