Needing some help please.
Posting this because I could not find a similar answeranywhere.
I have six worksheets… EF Copy, Stop 1, Stop 2, etc toStop 5
On the EF Copy worksheet is a download from our AS400 a deliverylist for a particular delivery route.
Worksheet shows Stop #, Customer, Product Description,Pack Size (of product), Quantity, Unit of Measure, and Customer PO number incolumns A thru G.
Each stop can have 1 to 100+ rows of items.
I need a formula so that worksheet Stop 1 only has Stop 1info, Stop 2 only Stop 2 info, and so on.
Got this working now but not well. Worksheet for stop 1 is fine… but the info onworksheet Stop 2 starts in the row where the info on worksheet Stop 1 ends,
I am sure I need an array formula w/ much more than justa normal VLookup.
Worksheet EFCopy (with ALL route info from the AS400 query):
<tbody>
</tbody>
Worksheet Stop 1:
<tbody>
</tbody><strike></strike>
<strike></strike>
Thanks for any assistance!
Posting this because I could not find a similar answeranywhere.
I have six worksheets… EF Copy, Stop 1, Stop 2, etc toStop 5
On the EF Copy worksheet is a download from our AS400 a deliverylist for a particular delivery route.
Worksheet shows Stop #, Customer, Product Description,Pack Size (of product), Quantity, Unit of Measure, and Customer PO number incolumns A thru G.
Each stop can have 1 to 100+ rows of items.
I need a formula so that worksheet Stop 1 only has Stop 1info, Stop 2 only Stop 2 info, and so on.
Got this working now but not well. Worksheet for stop 1 is fine… but the info onworksheet Stop 2 starts in the row where the info on worksheet Stop 1 ends,
I am sure I need an array formula w/ much more than justa normal VLookup.
Worksheet EFCopy (with ALL route info from the AS400 query):
Stop # | Institution | Description | Pack/Size | Qty | UOM | PO # |
1 | MACDONALDS | THICKENER NECTAR FD/BEV | 200/4.8GRAM | 4 | CS | 278 |
1 | MACDONALDS | BEAN GREEN GR B *GRADED* | 6/#10 | 16 | CS | 3610151 |
1 | MACDONALDS | BEAN VEGETARIAN SCE*GRADED* | 6/#10 | 10 | CS | 3610151 |
1 | MACDONALDS | BEET DICED *GRADED* C40118 | 6/10 | 12 | CS | 3610151 |
1 | MACDONALDS | POTATO WHOLE WHITE 60-80 CT C | 6/#10 | 6 | CS | 3610151 |
1 | MACDONALDS | YAM CUT FCY C40118 | 6/10 | 6 | CS | 3610151 |
1 | MACDONALDS | MUSHROOM PCS & STEMS INDIAM - | 6/#10 | 2 | CS | 3610151 |
1 | MACDONALDS | TOMATO DICED CHO *GRADED* | 6/10 | 10 | CS | 3610151 |
2 | HARDLEES | BROCCOLI FROZEN | 1/20# | 4 | CS | 905 |
2 | HARDLEES | VEGETABLE MIX FLORENTINE CALIF | 20/LB | 40 | CS | 905 |
2 | HARDLEES | POTATO ROUND | 6/5 LB | 50 | CS | 905 |
2 | HARDLEES | POTATO FRENCH FRY STRAIGHT | 6/5 LB | 3 | CS | 905 |
2 | HARDLEES | MARGARINE CUPS SOY OIL 5GM | 900/5 GM | 133 | CS | 911 |
2 | HARDLEES | MARGARINE CUPS SOY OIL 5GM | 900/5 GM | 133 | CS | 911 |
2 | HARDLEES | CHEESE AMERICAN BLD 160 SLC (I | 1/5# | 100 | EA | 963 |
3 | WINDYS | BROCCOLI FROZEN | 1/20# | 50 | CS | 904 |
3 | WINDYS | BROCCOLI FROZEN | 1/20# | 50 | CS | 904 |
3 | WINDYS | VEGETABLE MIX FLORENTINE CALIF | 20/LB | 33 | CS | 904 |
3 | WINDYS | POTATO ROUND | 6/5 LB | 100 | CS | 904 |
3 | WINDYS | POTATO FRENCH FRY STRAIGHT | 6/5 LB | 30 | CS | 904 |
<tbody>
</tbody>
Worksheet Stop 1:
Institution | Stop # | Description | Pack/Size | Qty | UOM | PO # |
MACDONALDS | 1 | THICKENER NECTAR FD/BEV | 200/4.8GRAM | 4 | CS | 278 |
MACDONALDS | 1 | BEAN GREEN GR B *GRADED* C401 | 6/#10 | 16 | CS | 3610151 |
MACDONALDS | 1 | BEAN VEGETARIAN SCE*GRADED* C4 | 6/#10 | 10 | CS | 3610151 |
MACDONALDS | 1 | BEET DICED *GRADED* C40118 | 6/10 | 12 | CS | 3610151 |
MACDONALDS | 1 | POTATO WHOLE WHITE 60-80 CT C | 6/#10 | 6 | CS | 3610151 |
MACDONALDS | 1 | YAM CUT FCY C40118 | 6/10 | 6 | CS | 3610151 |
MACDONALDS | 1 | MUSHROOM PCS & STEMS INDIAM - | 6/#10 | 2 | CS | 3610151 |
MACDONALDS | 1 | TOMATO DICED CHO *GRADED* C401 | 6/10 | 10 | CS | 3610151 |
<tbody>
</tbody>
<strike></strike>
Thanks for any assistance!