Countryboy69
Board Regular
- Joined
- Dec 7, 2018
- Messages
- 77
is there a macro that once an external file is open it pulls certain info from it and plugs it in to various sheets?
A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | JC 12/15/2018 | | | MONDAY TUESDAY WEDNESDAY THURSDAY FRIDAY | | | | | | | | INC BOX | | D-box | Disputes | | D.A.W | | |
2 | Barcode | Daughter B/C | W.A.D. | Full wt. | Empty wt. | Waste Wt. | Types | Destination | NPC/PSC | Notes | Full Wt. | Empty Wt. | Box # | Full Wt. | Full Wt. | Empty Wt. | Full Wt. | Empty Wt. | |
3 | 766535 | | | 7890 | 2505 | 5385 | 20 | | | | | | | | | | | | |
4 | | 88765 | | | | 0 | | HALL SIDE INTERMODAL | | | 7890 | 375 | P87 | 1250 | | | | | E/W |
5 | | 998676 | | | | 0 | | BIN SIDE INTERMODAL | | | | | | 990 | 6550 | 900 | 6700 | 2155 | F/W |
6 | | 9887 | | | | 0 | | BIN | | | 6545 | 2135 | O77 | | | | 1280 | 200 | WASTE WT |
7 | 9877 | | | 95050 | 3200 | 91850 | EXELON | | | | | | | | | | | | |
8 | | 99878 | | | | 0 | | BIN | | | | | | 1400 | | | 6550 | 1250 | |
9 | 9987 | | | 7805 | 2190 | 5615 | 40 | | | | | | | | | | | | |
Sheet: NOTES |
A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | Date | Barcode | Waste WT | 40 S/l | 20' S/l | B-25 | Drum | Exelon | Other | | DAW | EX metal | Metal | Time (in Min) | Customer | Total to Bin | Total to Inc | Total to Comp | Disputes | NOTES |
2 | | | | | | | | | | | | | | | | | | | | |
3 | JC 12/15/2018 | 766535 | 5385 | | X | | | | | | | | | | | | 11925 | 1980 | 5650 | |
4 | | 9877 | 91850 | | | | | X | | | 5300 | | | | | | 1270 | | | |
5 | | 9987 | 5615 | X | | | | | | | | | | | | | | | | |
Sheet: Sheet5 |