gUTTERMEDIC
New Member
- Joined
- Sep 16, 2014
- Messages
- 1
I have 30 items that are sold by 10 sales reps. Here is the report I get out of the as400.
520101 10/10 CT LINER CAN LL RL 36X58 55G BLK 365822G 13.00
520144 8/25 CT LINER CAN HD RL 38X60 60G NATURAL HD386017N 4.00
520152 10/10 CT LINER CAN LL 38X58 60G BLK 1.2ML 385830G 4.00
520373 100 CT LINER CAN LL RL 28X45 26G SLIM GRAY 284530G 3.00
Salesrep Totals 36.00
46 TODD
107638 1/ROLL FILM PVC 18" X 2000' CUTTER BOX 30550400 3.00
193275 1/ROLL FILM PVC ZIP SAFE 18"X 2M 30540474 1.00
520004 10/50 CT LINER CAN LL RL 24X32 10-16G GRAY 243222G 1.00
520073 100 CT LINER CAN LL 40X46 45G BLK .9ML 404622G 2.00
520152 10/10 CT LINER CAN LL 38X58 60G BLK 1.2ML 385830G 4.00
Salesrep Totals 11.00
48 CODY
107638 1/ROLL FILM PVC 18" X 2000' CUTTER BOX 30550400 2.00
193275 1/ROLL FILM PVC ZIP SAFE 18"X 2M 30540474 1.00
520073 100 CT LINER CAN LL 40X46 45G BLK .9ML 404622G 2.00
520101 10/10 CT LINER CAN LL RL 36X58 55G BLK 365822G 2.00
520128 8/25 CT LINER CAN HD RL 43X48 56G NATURAL HD434816N 1.00
520152 10/10 CT LINER CAN LL 38X58 60G BLK 1.2ML 385830G 3.00
The report covers one month. I would like to setup excel to enter this date each month and have it show each sale reps
items and how many sold. I know its already here, but need to use the data in charts to make the data visual. Like who sole the most this month. Them use each month on a year chart.
OK my problem is how do I do something like vlookup that will keep the salesmen seperate without having to format the report every month.
520101 10/10 CT LINER CAN LL RL 36X58 55G BLK 365822G 13.00
520144 8/25 CT LINER CAN HD RL 38X60 60G NATURAL HD386017N 4.00
520152 10/10 CT LINER CAN LL 38X58 60G BLK 1.2ML 385830G 4.00
520373 100 CT LINER CAN LL RL 28X45 26G SLIM GRAY 284530G 3.00
Salesrep Totals 36.00
46 TODD
107638 1/ROLL FILM PVC 18" X 2000' CUTTER BOX 30550400 3.00
193275 1/ROLL FILM PVC ZIP SAFE 18"X 2M 30540474 1.00
520004 10/50 CT LINER CAN LL RL 24X32 10-16G GRAY 243222G 1.00
520073 100 CT LINER CAN LL 40X46 45G BLK .9ML 404622G 2.00
520152 10/10 CT LINER CAN LL 38X58 60G BLK 1.2ML 385830G 4.00
Salesrep Totals 11.00
48 CODY
107638 1/ROLL FILM PVC 18" X 2000' CUTTER BOX 30550400 2.00
193275 1/ROLL FILM PVC ZIP SAFE 18"X 2M 30540474 1.00
520073 100 CT LINER CAN LL 40X46 45G BLK .9ML 404622G 2.00
520101 10/10 CT LINER CAN LL RL 36X58 55G BLK 365822G 2.00
520128 8/25 CT LINER CAN HD RL 43X48 56G NATURAL HD434816N 1.00
520152 10/10 CT LINER CAN LL 38X58 60G BLK 1.2ML 385830G 3.00
The report covers one month. I would like to setup excel to enter this date each month and have it show each sale reps
items and how many sold. I know its already here, but need to use the data in charts to make the data visual. Like who sole the most this month. Them use each month on a year chart.
OK my problem is how do I do something like vlookup that will keep the salesmen seperate without having to format the report every month.
Last edited: