P
praveen_khm
Hi all,
I have attached a spread sheet with a problem. This is the second time
am posting this thread. The last thread did not give me any help. So I
posted this again. 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. Against this,
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 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 using the itemID. If yes, omit that count.
Please all, I really need your help. I understand that this is messy
and problomatic. but I need your help. I tried to do the macro by
generating it. But the limitation is with the repeated invoice could
not be identified. Can anyone please help me with this? Any quick help
would be appreciated. Please help.
Thanks,
Praveen
+-------------------------------------------------------------------+
|Filename: Exp.zip |
|Download: http://www.excelforum.com/attachment.php?postid=4388 |
+-------------------------------------------------------------------+
I have attached a spread sheet with a problem. This is the second time
am posting this thread. The last thread did not give me any help. So I
posted this again. 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. Against this,
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 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 using the itemID. If yes, omit that count.
Please all, I really need your help. I understand that this is messy
and problomatic. but I need your help. I tried to do the macro by
generating it. But the limitation is with the repeated invoice could
not be identified. Can anyone please help me with this? Any quick help
would be appreciated. Please help.
Thanks,
Praveen
+-------------------------------------------------------------------+
|Filename: Exp.zip |
|Download: http://www.excelforum.com/attachment.php?postid=4388 |
+-------------------------------------------------------------------+