foodchemist
New Member
- Joined
- Jul 1, 2021
- Messages
- 8
- Office Version
- 365
- Platform
- Windows
I'm using a Dynamic report that is downloaded daily from a MySQL database and I'm wanting to be able to to sort items by their process step by being able to double-click on a cell with that text that would then generate a new sheet in the same workbook with all rows matching (some rows have two items that go together but might be at different processing steps, if so, leave the non-match part blank and still pull the other matching portion):
I already have a macro that sorts the information by date and generates a list on the right on side of how many items at a step:
So for instance, if I double-click "Pick" which states there are five items that are in the "Pick" step of processing, the new sheet it would generate would be:
So for Line 2, you see that GOLFA-23 is removed from the new sheet because it does not match (it is at the "In Wash" step) but I still need the main order info (2021-06-24, 832081, USA). So even if one of the two items match, I still need the rest of the row but I don't need the other item's info if it doesn't match the processing step.
Thanks for any help!
I already have a macro that sorts the information by date and generates a list on the right on side of how many items at a step:
Due Date | SMART Order | MFG Order | Ship Country | Box ID | Option | Current Step | Box Rack | Box Type | 2nd Box ID | Antisense Step | 2nd Box Rack | Number of Rushes | Garden | Processing |
2021-05-21 | 826370 | United Kingdom | XXPPL-123 | STD Juice | In Wash | 495462 | Carton | XXPPL-124 | Weigh | 496083 | 12 | Pick | Weigh | |
2021-05-21 | 826370 | United Kingdom | XXPPL-125 | STD Juice | Weigh | 496083 | Carton | XXPPL-126 | In Wash | 495472 | 5 | 5 | ||
2021-05-21 | 826370 | United Kingdom | XXPPL-127 | STD Juice | Weigh | 496083 | Carton | XXPPL-128 | In Wash | 494743 | Grow | Inspect | ||
2021-06-16 | 830958 | USA | MAJES-196 | Rinse Only | Pick | 0 | 0 | |||||||
2021-06-24 | 832081 | USA | GOLFA-23 | STD Juice | In Wash | 495620 | Grow | GOLFA-24 | Pick | 496348 | Bag | In Wash | ||
2021-06-25 | 832150 | 832152 | Japan | APPLE-53 | Barrel Age | Pick | 0 | 5 | ||||||
2021-06-25 | 832150 | 832152 | Japan | APPLE-54 | Barrel Age | Pick | Grow | APPLE-55 | Pick | Weigh | Taste Test | |||
2021-06-28 | 831677 | Germany | BERRY-19 | Ferment | Weigh | 496295 | Smash & Wash | 5 | 1 | |||||
2021-06-28 | 832573 | USA | LOGMC-32 | STD Juice | Pick | LOGMC-33 | In Wash | 495641 | 2nd Weigh | Barrel Test | ||||
2021-06-28 | 832636 | 832637 | Canada | XXPPL-204 | STD Juice | Washed | 496376 | Stock | XXPPL-205 | Juiced | 496259 | 0 | 0 | |
2021-06-29 | 832201 | USA | STRBY-12 | Barrel Age | Pick | Washed | ||||||||
2021-06-29 | 831856 | France | OLEVO-55 | Ferment | Taste Test | 496343 | Smash & Wash | 1 | ||||||
2021-07-04 | 832501 | USA | SPLCE-21 | STD Juice | Washed | 496359 | Juice | SPLCE-22 | Juiced | 495749 | Juiced | |||
2021-07-15 | 832501 | USA | SPLCE-23 | STD Juice | Washed | 496359 | Juice | SPLCE-24 | Juiced | 495807 | 1 |
So for instance, if I double-click "Pick" which states there are five items that are in the "Pick" step of processing, the new sheet it would generate would be:
2021-06-16 | 830958 | USA | MAJES-196 | Rinse Only | Pick | ||||||
2021-06-24 | 832081 | USA | Grow | GOLFA-24 | Pick | 496348 | |||||
2021-06-25 | 832150 | 832152 | Japan | APPLE-53 | Barrel Age | Pick | |||||
2021-06-25 | 832150 | 832152 | Japan | APPLE-54 | Barrel Age | Pick | Grow | APPLE-55 | Pick | ||
2021-06-28 | 832573 | USA | LOGMC-32 | STD Juice | Pick | ||||||
2021-06-29 | 832201 | USA | STRBY-12 | Barrel Age | Pick |
So for Line 2, you see that GOLFA-23 is removed from the new sheet because it does not match (it is at the "In Wash" step) but I still need the main order info (2021-06-24, 832081, USA). So even if one of the two items match, I still need the rest of the row but I don't need the other item's info if it doesn't match the processing step.
Thanks for any help!