P
praveen_khm
Hi all,
I have attached a spread sheet with this problem. I desperately need
you guys help to solve this problem. The report attached here gives the
daily update of the invoices. Column 2 (Process), 5(Status) and 13(Item
ID) are the areas of interest. This is a repeated report which I get
everyday. I ll tell you all what is really necessary:
1. I ll paste the present days data in sheet1 and previous days data in
sheet2
2. The macro should create a table in sheet 3 which gives a count of
all individually. i.e, the columns should contain RDE, ECM, POCORE,
NONPO, Blanks as in the drop down of column 2. Horizantally, I need the
count of all these as New, completed, Problem, wastebasked, blanks. It
should form a table for this. (as an example, I have shown in sheet3 in
the attached example sheet)
One problem in this is that there might be a repeated invoice. So,
while taking the present days data, the Unique item ID in column 13
should be compared with the previous day. i.e, the "new" for previous
day may be repeated in today's report which should not happen. So the
solution for this is check if the NEW in present day exist in the NEW
of previous day. If yes, omit that count.
Please all, I really need your help. I understand that this is messy
and problomatic. But I thought this is the only place for help. I tried
to do the macro by generating it. But the limitation is with the
repeated invoice which could not be identified. Can anyone please help
on this? I need to submit this matrix by tomorrow. Any quick help would
be appreciated. Please help.
Thanks,
Praveen.
+-------------------------------------------------------------------+
|Filename: Exp.zip |
|Download: http://www.excelforum.com/attachment.php?postid=4378 |
+-------------------------------------------------------------------+
I have attached a spread sheet with this problem. I desperately need
you guys help to solve this problem. The report attached here gives the
daily update of the invoices. Column 2 (Process), 5(Status) and 13(Item
ID) are the areas of interest. This is a repeated report which I get
everyday. I ll tell you all what is really necessary:
1. I ll paste the present days data in sheet1 and previous days data in
sheet2
2. The macro should create a table in sheet 3 which gives a count of
all individually. i.e, the columns should contain RDE, ECM, POCORE,
NONPO, Blanks as in the drop down of column 2. Horizantally, I need the
count of all these as New, completed, Problem, wastebasked, blanks. It
should form a table for this. (as an example, I have shown in sheet3 in
the attached example sheet)
One problem in this is that there might be a repeated invoice. So,
while taking the present days data, the Unique item ID in column 13
should be compared with the previous day. i.e, the "new" for previous
day may be repeated in today's report which should not happen. So the
solution for this is check if the NEW in present day exist in the NEW
of previous day. If yes, omit that count.
Please all, I really need your help. I understand that this is messy
and problomatic. But I thought this is the only place for help. I tried
to do the macro by generating it. But the limitation is with the
repeated invoice which could not be identified. Can anyone please help
on this? I need to submit this matrix by tomorrow. Any quick help would
be appreciated. Please help.
Thanks,
Praveen.
+-------------------------------------------------------------------+
|Filename: Exp.zip |
|Download: http://www.excelforum.com/attachment.php?postid=4378 |
+-------------------------------------------------------------------+
