Spreadsheet: 92061d1291736105-how-do-i-copy-a-value-to-from-one-sheet-to-another-by-looking-up-values-in-3-columns-registration-workbook
Sheet: Main

Choose Yes or No from Drop-Down List |  |  |  |  | Add 1 to the value above |  |  | [NAME] and DEC Region from Drop-Down List |  |  |  |  |  | For Phone Number: Enter area code and 7 digit phone number without spaces or dashes |  |  |  |  | Enter Dates in Format MM/DD/YYYY |  |  | Choose Yes or No from Drop-Down List |  | Enter Dates in Format MM/DD/YYYY |  |  |  | Enter Date in Format MM/DD/YYYY |  |  | Enter File Name, then Right-click and [NAME] | Enter Date in Format MM/DD/YYYY | Enter any relevant notes (include date and your initials).
Registrant Type |  |  |  |  |  |  |  | Location Information |  |  |  |  |  | Contact Information |  |  |  |  | Date Documents Received |  |  |  |  | Payment Information |  |  |  | Status
Manuf | Collective | Collection | Consol | Recycl | Registration_Num | Registrant_Name | Fed_Tax_ID | Address | City | State | Zip | Country | DEC_Region | Cont_FirstName | Cont_LastName | Cont_Phone | Cont_Fax | Cont_Email | Registration_Form | Fee_Form | Payment | Certification_Signed | Registration_Complete | Check_Num | Check_Date | Check_Amount | Date_Processed_to_FMIS | Date_Reviewed | Reviewed_By | Acceptable | EDocument_Link | Date_of_Last_Update | Notes
Yes | No | No | No | No | 1 | A Manufacturer | 123 | 1 Main St. | Albany | NY | 12233 | USA | 4 | [NAME] | Smith | 5185551111 | 5185552222 | [EMAIL] | 2010-11-30 00:00:00 | 2010-11-30 00:00:00 | 2010-11-30 00:00:00 | Yes | Yes | 186 | 2010-11-30 00:00:00 | 500 | 2010-12-01 00:00:00 | 2010-12-01 00:00:00 | SMR | Yes | Link 1 | 2010-12-06 00:00:00 | [NAME]
No | Yes | No | No | No | 2 | ABC Collective | 456 | 300 Broadway | Newburgh | NY | 10000 | USA | 3 | [NAME] | Doe | 8455551111 | 8455553333 | [EMAIL] | 2010-12-02 00:00:00 | 2010-12-02 00:00:00 |  | Yes | No - Fee issue |  |  |  |  | 2010-12-05 00:00:00 | SMR | No | Link 2 | 2010-12-05 00:00:00 | [NAME]
No | No | Yes | No | No | 3 | 123 Collection Facility |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Link 3
No | No | No | Yes | No | 4 | A Consolidator |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Link 4
No | No | No | No | Yes | 5 | A [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Link 5
No | Yes | No | Yes | No | 6 | Collective Consolidator |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Link 6
Yes | No | No | No | Yes | 7 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Link 7
No | No | No | Yes | Yes | 8 | Consolidator [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Link 8
Yes | Yes | Yes | Yes | Yes | 9 | Super Facility |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Link 9
Yes | No | No | No | No | 10 | B_Manufacturer |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Link 10
No | Yes | No | No | No | 11 | [NAME] | 999 | 562 Oak St. | Some City | NY | 11111 | USA | 5 | Dude | Jones | 5555555555 | 5555559999 | [EMAIL] | 2010-12-02 00:00:00 | 2010-12-03 00:00:00 | 2010-12-03 00:00:00 | Yes | Yes | 500 | 2010-12-02 00:00:00 | 500 | 2010-12-03 00:00:00 | 2010-12-05 00:00:00 | Somebody | Yes | Link 11 | 2010-12-06 00:00:00 | Notes!
No | Yes | No | No | No | 12 | 123 Collective | 888 | 600 Main St. | Albany | NY | 12233 | USA | 4 | First | Last | 5184025555 | 5184025556 | [EMAIL] | 2010-12-06 00:00:00 | 2010-12-07 00:00:00 | 2010-12-07 00:00:00 | Yes | Yes | 1 | 2010-12-07 00:00:00 | 500 | 2010-12-07 00:00:00 | 2010-12-07 00:00:00 | Me | Yes | Link 12 | 2010-12-07 00:00:00 | More Notes!