Spreadsheet: 203702d1357227974-auto-populate-cells-with-corresponding-data-from-a-different-worksheet-master-sheet
Sheet: Sheet1

Master [NAME]
Sample # | Date Test Requested | Requested By | Rep | RA# | Order Number | Account # | Company | Received | Supplier | Date of Manufacture | Item Description | Color | Lot Number | [NAME] | Amount | Desired Testing | Defective Not Defective | Sample # | Due Date | Completed | Internal Comments
T2012-001 | 2012-01-06 00:00:00 | RETURNS | [NAME] | X44245-12122011 | 44245 | 55112 | [NAME]'s Place | 2012-01-09 00:00:00 | Supplier A | 2011-08-19 00:00:00 | Product A | Navy | ABC | 20" | 1 | QUALITY | Defective | T2012-001 | 2012-11-25 00:00:00 | 2012-02-15 00:00:00 | This material sucks
T2012-002 | 2012-01-06 00:00:00 | RETURNS | [NAME] | n/a | 44242 | 5222 | [NAME] | 2012-01-09 00:00:00 | Supplier B | n/a | Product B | Vegas Gold | DEF |  |  | INTERNAL |  | T2012-002 | 2012-11-26 00:00:00
T2012-003 | 2012-01-06 00:00:00 | RETURNS | Billy | n/a | 6616387 | 1115722 | [NAME]'s Place | 2012-01-06 00:00:00 | Supplier C | 2011-09-07 00:00:00 | Product C | White | GHI | 20 | 50 | CUSTOMER | Not Defective | T2012-003 | 2012-11-27 00:00:00 | 2012-01-09 00:00:00 | This material does not suck
T2012-004 | 2012-01-09 00:00:00 | RETURNS | [NAME] | X42254-1205512 | 444232 | n/a | [NAME]'s place | 2012-01-06 00:00:00 | Supplier X | n/a | Product X | White | TUY | 30 | 10 | SUPPORT | Defective | T2012-004 | 2012-11-28 00:00:00 | 2012-01-17 00:00:00 | This material sucks
T2012-005 | 2012-01-09 00:00:00 | RETURNS | [NAME] | n/a | 4752 | 50046 | Christy's Place | 2012-01-09 00:00:00 | Supplier Y | n/a | Product Y | White | WXY | 30 | 10 | QUALITY | Defective | T2012-005 | 2012-11-29 00:00:00 | 2012-01-17 00:00:00 | This material sucks
T2012-006 | 2012-01-10 00:00:00 | RETURNS | [NAME] | X44245-12122012 | 5475454 | 13238 | [NAME]'s Place | 2012-01-11 00:00:00 | Supplier Z | n/a | Product Z | orange/navy | ABC | Garment sample | Garment sample | INTERNAL | Not Defective | T2012-006 | 2012-11-30 00:00:00 | 2012-01-11 00:00:00 | This material does not suck
T2012-007 | 2012-01-10 00:00:00 | RETURNS | Alicia | n/a | 5452123 | 55112 | [NAME] | 2012-01-11 00:00:00 | Supplier A | 2011-10-10 00:00:00 | Product A | White | DEF | 20" | 7 | CUSTOMER | Defective | T2012-007 | 2012-12-01 00:00:00 | 2012-01-18 00:00:00 | This material sucks
T2012-008 | 2012-01-10 00:00:00 | RETURNS | [NAME] | n/a | 645643 | 5222 | [NAME]'s Place | 2012-01-11 00:00:00 | Supplier B | n/a | Product B | White | GHI | 34" | 1 | SUPPORT | Defective | T2012-008 | 2012-12-02 00:00:00 | 2012-01-28 00:00:00 | This material sucks
T2012-009 | 2012-01-11 00:00:00 | RETURNS | [NAME] | X42254-1205513 | 5443413 | 1115722 | [NAME]'s place | 2012-01-09 00:00:00 | Supplier C | n/a | Product C | White | TUY | 30 | 150 | QUALITY | Defective | T2012-009 | 2012-12-03 00:00:00 | 2012-01-17 00:00:00 | This material sucks
T2012-010 | 2012-01-11 00:00:00 | RETURNS | Billy | n/a | 546464 | n/a | Christy's Place | 2012-01-11 00:00:00 | Supplier X | n/a | Product X | Columbia/White | WXY | N/A | Letters | INTERNAL | Defective | T2012-010 | 2012-12-04 00:00:00 | 2012-01-28 00:00:00 | This material sucks
T2012-011 | 2012-01-13 00:00:00 | RETURNS | [NAME] | X44245-12122013 | 548784 | 23570 | [NAME]'s Place | 2012-01-16 00:00:00 | Supplier Y | n/a | Product Y | n/a | ABC | [NAME] | [NAME] | CUSTOMER | Defective | T2012-011 | 2012-12-05 00:00:00 | 2012-01-16 00:00:00 | This material sucks
T2012-012 | 2012-01-13 00:00:00 | RETURNS | [NAME] | n/a | 566446 | 60378 | [NAME] | 2012-01-16 00:00:00 | Supplier Z | 2011-12-13 00:00:00 | Product Z | Purple | DEF | 16" | 23 | SUPPORT | Not Defective | T2012-012 | 2012-12-06 00:00:00 | 2012-02-16 00:00:00 | This material does not suck
T2012-013 | 2012-01-16 00:00:00 | RETURNS | [NAME] | n/a | 54141654 | 55112 | [NAME]'s Place | 2012-01-17 00:00:00 | Supplier A | n/a | Product A | Black | GHI | 20" | <1 | QUALITY | Not Defective | T2012-013 | 2012-12-07 00:00:00 | 2011-01-31 00:00:00 | This material does not suck
T2012-014 | 2012-01-09 00:00:00 | RETURNS | Alicia | X42254-1205514 | 43413 | 5222 | [NAME]'s place | 2012-01-09 00:00:00 | Supplier B | n/a | Product B | White | TUY | 30 | n/a | INTERNAL | Defective | T2012-014 | 2012-12-08 00:00:00 | 2012-01-17 00:00:00 | This material sucks
T2012-015 | 2012-01-17 00:00:00 | RETURNS | [NAME] | n/a | 21546492 | 1115722 | Christy's Place | 2012-01-18 00:00:00 | Supplier C | n/a | Product C | White | WXY | 34" | 25 | CUSTOMER | Defective | T2012-015 | 2012-12-09 00:00:00 | 2012-03-01 00:00:00 | This material sucks
T2012-016 | 2012-01-10 00:00:00 | RETURNS | [NAME] | X44245-12122014 | 334341 | n/a | [NAME]'s Place | 2012-01-20 00:00:00 | Supplier X | n/a | Product X | Cream | ABC | Sample | 2 | SUPPORT | Defective | T2012-016 | 2012-12-10 00:00:00 | 2012-01-24 00:00:00 | This material sucks
T2012-017 | 2012-11-18 00:00:00 | RETURNS | Billy | n/a | 313210 | 97186 | [NAME] | 2012-01-18 00:00:00 | Supplier Y | n/a | Product Y | Orange | DEF | 20 | 50 | QUALITY | Defective | T2012-017 | 2012-12-11 00:00:00 | 2012-02-12 00:00:00 | This material sucks
T2012-018 | 2012-01-20 00:00:00 | RETURNS | [NAME] | n/a | 542132 | 133994 | [NAME]'s Place | 2012-01-20 00:00:00 | Supplier Z | n/a | Product Z | White | GHI |  |  | INTERNAL | Defective | T2012-018 | 2012-12-12 00:00:00 | 2012-02-21 00:00:00 | This material sucks
T2012-019 | 2012-01-24 00:00:00 | RETURNS | [NAME] | X42254-1205515 | 545121 | 55112 | [NAME]'s place | 2012-01-27 00:00:00 | Supplier A | 2012-07-29 00:00:00 | Product A | Green | TUY | 20" | 19 | CUSTOMER | Defective | T2012-019 | 2012-12-13 00:00:00 | 2012-02-23 00:00:00 | This material sucks
T2012-020 | 2012-01-24 00:00:00 | RETURNS | [NAME] | n/a | 35421 | 5222 | Christy's Place | 2012-01-27 00:00:00 | Supplier B | n/a | Product B | White | WXY | N/A | Letters | SUPPORT | Not Defective | T2012-020 | 2012-12-14 00:00:00 | 2012-02-10 00:00:00 | This material does not suck
T2012-021 | 2012-01-24 00:00:00 | RETURNS | Alicia | X44245-12122015 | 574833 | 1115722 | [NAME]'s Place | 2012-01-27 00:00:00 | Supplier C | n/a | Product C | Gold | ABC | 20" | 3 | QUALITY | Not Defective | T2012-021 | 2012-12-15 00:00:00 | 2012-02-16 00:00:00 | This material does not suck
T2012-022 | 2012-01-26 00:00:00 | RETURNS | [NAME] | n/a | 3354567 | n/a | [NAME] | 2012-01-30 00:00:00 | Supplier X | n/a | Product X | White | DEF | N/A | garments | INTERNAL | Defective | T2012-022 | 2012-12-16 00:00:00 | 2012-02-23 00:00:00 | This material sucks
T2012-023 | 2012-01-26 00:00:00 | RETURNS | [NAME] | n/a | 545343 | 170802 | [NAME]'s Place | 2012-01-30 00:00:00 | Supplier Y | n/a | Product Y | White/Red | GHI | N/A | Letters | CUSTOMER | Defective | T2012-023 | 2012-12-17 00:00:00 | 2012-02-10 00:00:00 | This material sucks
T2012-024 | 2012-01-30 00:00:00 | RETURNS | Billy | X42254-1205516 | 54341 | 207610 | [NAME]'s place | 2012-01-30 00:00:00 | Supplier Z | n/a | Product Z | Clear | TUY | n/a | graphics | SUPPORT | Not Defective | T2012-024 | 2012-12-18 00:00:00 | 2011-03-01 00:00:00 | This material does not suck
T2012-025 | 2012-01-30 00:00:00 | RETURNS | [NAME] | n/a | 33354 | 55112 | Christy's Place | 2012-01-30 00:00:00 | Supplier A | n/a | Product A | Sky Blue | WXY | 15 | 10 | QUALITY | Defective | T2012-025 | 2012-12-19 00:00:00 | 2012-01-31 00:00:00 | This material sucks
T2012-026 | 2012-01-31 00:00:00 | RETURNS | [NAME] | X44245-12122016 | 222465 | 5222 | [NAME]'s Place | 2012-01-31 00:00:00 | Supplier B | n/a | Product B | White | ABC | 30 | n/a | INTERNAL | Defective | T2012-026 | 2012-12-20 00:00:00 | 2012-02-22 00:00:00 | This material sucks
T2012-027 | 2012-02-02 00:00:00 | RETURNS | [NAME] | n/a | 574543 | 1115722 | [NAME] | 2012-02-02 00:00:00 | Supplier C | n/a | Product C | Purple | DEF | 30 | n/a | CUSTOMER | Defective | T2012-027 | 2012-12-21 00:00:00 | 2012-02-22 00:00:00 | This material sucks
T2012-028 | 2012-02-07 00:00:00 | RETURNS | Alicia | n/a | 545784 | n/a | [NAME]'s Place | 2012-02-08 00:00:00 | Supplier X | 2012-01-10 00:00:00 | Product X | white | GHI | 16" | 10 | SUPPORT | Defective | T2012-028 | 2012-12-22 00:00:00 | 2012-02-24 00:00:00 | This material sucks
T2012-029 | 2012-02-07 00:00:00 | RETURNS | [NAME] | X42254-1205517 | 54542 | 244418 | [NAME]'s place | 2012-02-08 00:00:00 | Supplier Y | 2011-01-28 00:00:00 | Product Y | Royal | TUY | 16" | 15 | QUALITY | Defective | T2012-029 | 2012-12-23 00:00:00 | 2012-02-24 00:00:00 | This material sucks
T2012-030 | 2012-02-07 00:00:00 | RETURNS | [NAME] | n/a | 22217 | 281226 | Christy's Place | 2012-02-08 00:00:00 | Supplier Z | 2010-04-19 00:00:00 | Product Z | White | WXY | 20" | 2 | INTERNAL | Defective | T2012-030 | 2012-12-24 00:00:00 | 2012-02-23 00:00:00 | This material sucks
T2012-031 | 2012-02-07 00:00:00 | RETURNS | Billy | X44245-12122017 | 333744 | 55112 | [NAME]'s Place | 2012-02-08 00:00:00 | Supplier A | n/a | Product A | white | ABC | N/A | 5 | CUSTOMER | Defective | T2012-031 | 2012-12-25 00:00:00 | 2010-02-23 00:00:00 | This material sucks
T2012-032 | 2012-02-07 00:00:00 | RETURNS | [NAME] | n/a | 3543211 | 5222 | [NAME] | 2012-02-08 00:00:00 | Supplier B | 2012-01-13 00:00:00 | Product B | Clear | DEF | 15" | 7 | SUPPORT | Not Defective | T2012-032 | 2012-12-26 00:00:00 | 2012-02-16 00:00:00 | This material does not suck
T2012-033 | 2012-02-07 00:00:00 | RETURNS | [NAME] | n/a | 145731 | 1115722 | [NAME]'s Place | 2012-02-08 00:00:00 | Supplier C | n/a | Product C | Fuchsia | GHI | N/A | N/A | QUALITY | Not Defective | T2012-033 | 2012-12-27 00:00:00 | 2012-02-22 00:00:00 | This material does not suck
T2012-034 | 2012-02-07 00:00:00 | RETURNS | [NAME] | X42254-1205518 | 2215747 | n/a | [NAME]'s place | 2012-02-08 00:00:00 | Supplier X | 2012-01-23 00:00:00 | Product X | Purple | TUY | 20" | 7 | INTERNAL | Defective | T2012-034 | 2012-12-28 00:00:00 | 2012-02-16 00:00:00 | This material sucks
T2012-035 | 2012-02-14 00:00:00 | RETURNS | Alicia | n/a | 665300 | 318034 | Christy's Place | 2012-02-14 00:00:00 | Supplier Y | 2012-01-26 00:00:00 | Product Y | White | WXY | 20" | Piece | CUSTOMER | Not Defective | T2012-035 | 2012-12-29 00:00:00 | 2012-02-24 00:00:00 | This material does not suck
T2012-036 | 2012-02-14 00:00:00 | RETURNS | [NAME] | X44245-12122018 | 343543 | 354842 | [NAME]'s Place | 2012-02-14 00:00:00 | Supplier Z | n/a | Product Z | White | ABC | N/A | Piece | SUPPORT | Not Defective | T2012-036 | 2012-12-30 00:00:00 | 2012-02-20 00:00:00 | This material does not suck
T2012-037 | 2012-02-14 00:00:00 | RETURNS | [NAME] | n/a | 7829085 | 55112 | [NAME] | 2012-02-16 00:00:00 | Supplier A | n/a | Product A | Orange | DEF | 20" | 10 | QUALITY | Not Defective | T2012-037 | 2012-12-31 00:00:00 | 2012-02-23 00:00:00 | This material does not suck
T2012-038 | 2012-02-14 00:00:00 | RETURNS | Billy | n/a | 54482 | 5222 | [NAME]'s Place | 2012-02-16 00:00:00 | Supplier B | 2011-12-30 00:00:00 | Product B | White | GHI | 20" | 50 | INTERNAL | Defective | T2012-038 | 2013-01-01 00:00:00 | 2012-02-23 00:00:00 | This material sucks
T2012-039 | 2012-02-14 00:00:00 | RETURNS | [NAME] | X42254-1205519 | 259808 | 1115722 | [NAME]'s place | 2012-02-16 00:00:00 | Supplier C | n/a | Product C | White | TUY | N/A | Letters | CUSTOMER | Not Defective | T2012-039 | 2013-01-02 00:00:00 | 2012-02-23 00:00:00 | This material does not suck
T2012-040 | 2012-02-14 00:00:00 | RETURNS | [NAME] | n/a | 99729 | n/a | Christy's Place | 2012-02-16 00:00:00 | Supplier X | n/a | Product X | n/a | WXY | 16 x 20 | 1 | SUPPORT | Defective | T2012-040 | 2013-01-03 00:00:00 | 2012-02-16 00:00:00 | This material sucks
T2012-041 | 2012-02-15 00:00:00 | RETURNS | [NAME] | X44245-12122019 | 8234 | 391650 | [NAME]'s Place | 2012-02-16 00:00:00 | Supplier Y | 2012-08-16 00:00:00 | Product Y | White | ABC | 15" | 15 | QUALITY | Not Defective | T2012-041 | 2013-01-04 00:00:00 | 2012-02-23 00:00:00 | This material does not suck
T2012-042 | 2012-02-02 00:00:00 | RETURNS | Alicia | n/a | 200805 | 428458 | [NAME] | 2012-02-16 00:00:00 | Supplier Z | n/a | Product Z | Silver | DEF | 15" | 5 | INTERNAL |  | T2012-042 | 2013-01-05 00:00:00
T2012-043 | 2012-02-20 00:00:00 | RETURNS | [NAME] | n/a | 29593 | 55112 | [NAME]'s Place | 2012-02-21 00:00:00 | Supplier A | n/a | Product A | White | GHI | Logo | Jacket | CUSTOMER | Not Defective | T2012-043 | 2013-01-06 00:00:00 | 2012-02-24 00:00:00 | This material does not suck
T2012-044 | 2012-02-20 00:00:00 | RETURNS | [NAME] | X42254-1205520 | 282352 | 5222 | [NAME]'s place | 2012-02-21 00:00:00 | Supplier B | n/a | Product B | Black | TUY | 20" | 50 | SUPPORT | Defective | T2012-044 | 2013-01-07 00:00:00 | 2012-03-19 00:00:00 | This material sucks
T2012-045 | 2012-02-21 00:00:00 | RETURNS | Billy | n/a | 242582 | 1115722 | Christy's Place | 2012-02-21 00:00:00 | Supplier C | n/a | Product C | n/a | WXY | n/a | n/a | QUALITY | Defective | T2012-045 | 2013-01-08 00:00:00 | 2012-04-17 00:00:00 | This material sucks
T2012-046 | 2012-02-21 00:00:00 | RETURNS | [NAME] | X44245-12122020 | 234241 | n/a | [NAME]'s Place | 2012-02-27 00:00:00 | Supplier X | n/a | Product X | White | ABC | 28" | 93 | INTERNAL | Defective | T2012-046 | 2013-01-09 00:00:00 | 2012-03-07 00:00:00 | This material sucks
T2012-047 | 2012-02-23 00:00:00 | RETURNS | [NAME] | n/a | 124055 | 465266 | [NAME] | 2012-02-23 00:00:00 | Supplier Y | n/a | Product Y | White | DEF | 20" | 1 | CUSTOMER |  | T2012-047 | 2013-01-10 00:00:00
T2012-048 | 2012-02-23 00:00:00 | RETURNS | [NAME] | n/a | 22385 | 502074 | [NAME]'s Place | 2012-02-23 00:00:00 | Supplier Z | n/a | Product Z | Navy | GHI | 17" | ? | SUPPORT | Defective | T2012-048 | 2013-01-11 00:00:00 | 2012-04-12 00:00:00 | This material sucks
T2012-049 | 2012-02-24 00:00:00 | RETURNS | Alicia | X42254-1205521 | 234599 | 55112 | [NAME]'s place | 2012-02-27 00:00:00 | Supplier A | n/a | Product A | White | TUY | 11x17 | 100 sheets | QUALITY | Not Defective | T2012-049 | 2013-01-12 00:00:00 | 2012-04-18 00:00:00 | This material does not suck
T2012-050 | 2012-02-24 00:00:00 | RETURNS | [NAME] | n/a | 244911 | 5222 | Christy's Place | 2012-02-27 00:00:00 | Supplier B | n/a | Product B | Orange | WXY | 20" | 6 | INTERNAL | Not Defective | T2012-050 | 2013-01-13 00:00:00 | 2012-03-19 00:00:00 | This material does not suck