Hi,

I've a set of data for the following:

Products 8/1 8/2 8/3 8/4 8/5 8/6 8/7
Plan Type A 0 0 0 60000 60000 20000 0
Result Type A 0 20000 0 40000 80000 20000

Using macros of the above Plan & Result
Output as below
Plan Result Diff Qty On schedule
Type A 8/4 8/5 -1 20000 20000
Type A 8/4 8/7 -3 20000 0
Type A 8/4 -999 20000 0
Type A 8/5 -999 60000 0
Type A 8/6 -999 20000 0

Note: -999 = No results

Thanks

S

The data by itself in this case doesn't give enough information to write a
macro. You need to be more specific. Why doesn't 8/2 have data in the
results. Why does 1st results have the dates 8/34 and 8/5 while the 2nd
results have dates 8/4 and 8/7?

"sengtng1" wrote:

Hi,

I've a set of data for the following:

Products 8/1 8/2 8/3 8/4 8/5 8/6 8/7
Plan Type A 0 0 0 60000 60000 20000 0
Result Type A 0 20000 0 40000 80000 20000

Using macros of the above Plan & Result
Output as below
Plan Result Diff Qty On schedule
Type A 8/4 8/5 -1 20000 20000
Type A 8/4 8/7 -3 20000 0
Type A 8/4 -999 20000 0
Type A 8/5 -999 60000 0
Type A 8/6 -999 20000 0

Note: -999 = No results

Thanks

S

You can't post spreadsheets on this site.

"sengtng1" wrote:

Hi Joel,
I've attached the spreesheet. The dates started from 8/11 instead of
8/1. Can you help. Thank in advance.

sengtng1




Joel wrote:
The data by itself in this case doesn't give enough information to write a
macro. You need to be more specific. Why doesn't 8/2 have data in the
results. Why does 1st results have the dates 8/34 and 8/5 while the 2nd
results have dates 8/4 and 8/7?

"sengtng1" wrote:

Hi,

I've a set of data for the following:

Products 8/1 8/2 8/3 8/4 8/5 8/6 8/7
Plan Type A 0 0 0 60000 60000 20000 0
ResultType A 0 20000 0 40000 80000 20000

Using macros of the above Plan & Result
Output as below
Plan Result Diff Qty On schedule
Type A 8/4 8/5 -1 20000 20000
Type A 8/4 8/7 -3 20000 0
Type A 8/4 -999 20000 0
Type A 8/5 -999 60000 0
Type A 8/6 -999 20000 0

Note: -999 = No results

Thanks

S