Spreadsheet: 167913d1342155624-copy-indirect-validation-from-one-worksheet-to-another-sample
Sheet: DATA

 | IC_1 | Engage_Tone
 | IC_2 | Powersuply_Issue\No_Dial_Tone
 | IC_3 | No_dial_tone
 | IC_4 | Voice_not_clear
 | IC_5 | Line_Short\Cross_Connection |  |  |  |  | Validation works in this sheet where data is present attached to it.. But if u c next sheet it wont work
 | IC_6 | Ups_Problem
 | IC_7 | No_Outgoing\Incoming
 | CA | Camera_Problem |  |  |  |  | IC_5 | Line_Short\Cross_Connection | IC_54 | Krone Wiring  Problem
 | NW | BLM_Problem
 | SP_1 | IPTV
 | SP_2 | Broadband
 | SP_3 | [NAME]
 | SP_4 | SP_others_Issue\All_Services_Down
 | SP_5 | SP_Resolved _By_Radius
 | SP_6 | SP_Shifting\Fixing_Request
 | SP_7 | SP_ONT_Related_Problem
 | OTH | Others
 | NC_1 | Shifting\Fixing_Request
 | NC_2 | New_Connection_Request
 | NC_3 | QC\PM\Site_Visit
 | NC_4 | Parallel_Connection\Remigration
 | NC_5 | ONT_Removed\Uninstallation
 | NC_6 | DBMS\Report_Update
 | NC_7 | Old_MTNL_Problem
 | NC_8 | Customer_Inquiry
 | OUT_1 | Planned_Outage
 | OUT_2 | Unplanned_Outage
 | IC_1 | Engage_Tone | IC_11 | IC_31 | IC_51 | IC_61 | IC_71 | [NAME] hang | Link not stable | [NAME] cord problem | UPS card faulty | Radius Instrument problem (Guard Room)
 | IC_2 | Powersuply_Issue\No_Dial_Tone | IC_12 | IC_32 | IC_52 | IC_62 | IC_72 | Configuration issue | Fiber/ pigtail break | ONT connection problem | UPS fuse blown | [NAME] faulty
 | IC_3 | No_dial_tone | IC_13 | IC_33 | IC_53 | IC_63 | IC_73 | [NAME] faulty | [NAME] faulty | ONT/ ONU Wiring Problem | UPS wiring problem | Configuration Issue
 | IC_4 | Voice_not_clear |  | IC_34 | IC_54 | IC_64 | IC_74 |  | No Link/ Power loss | Krone Wiring  Problem | Connector problem | [NAME]
 | IC_5 | Line_Short\Cross_Connection | IC_21 |  |  | IC_65 | IC_75 | Male/ Female connector problem |  |  | Battery Problem | ONT/ ONU port faulty
 | IC_6 | Ups_Problem | IC_22 | IC_41 |  |  |  | Adaptor problem | Configuration issue
 | IC_7 | No_Outgoing\Incoming |  | IC_42 |  |  |  |  | ONT/ONU  wiring problem
 | CA | Camera_Problem | CA_1 | CA_5 |  |  |  | Power supply issue | Network cabling issue
 |  |  | CA_2 | CA_6 |  |  |  | UPS problem | Configuration issue
 |  |  | [NAME] | CA_7 |  |  |  | Camera / Network switch problem | [NAME] hang
 |  |  | CA_4 |  |  |  |  | Camera/ Computer hang
 | NW | BLM_Problem | NW_1 |  |  |  |  | BLM Configuration specific problem
 |  | SIP_Server_Problem | NW_2 |  |  |  |  | SIP Configuration specific problem
 | SP_1 | IPTV | SP_11 | SP_51 | SP_55 | SP_61 |  | IPTV not working | STB hang | RJ 45 Connector problem | IPTV/ Broadband/ VoIP Shifting
 | SP_2 | Broadband | [NAME] | [NAME] | SP_56 | SP_71 |  | Internet not working | Router hang | Router Reset | All services down/ IPTV, Broadband, [NAME] problem from ONT
 | SP_3 | [NAME] | SP_31 | SP_53 | SP_57 |  |  | Telephone / Landline not working | IAD hang | Broadband Password Changed
 | SP_4 | SP_others_Issue\All_Services_Down | SP_41 | SP_54 | SP_58 |  |  | IPTV/ Broadband/ [NAME] not working | LAN cable problem | N/W switch problem
 | SP_5 | SP_Resolved_By_Radius
 | SP_6 | SP_Shifting\Fixing_Request
 | SP_7 | SP_ONT_Related_Problem
 | OTH | Others | OTH_01 | OTH_07 |  |  |  | Instrument Problem | Wifi/ STB/ TV/ Remote/ PC/ Laptop problem
 |  |  | OTH_02 | OTH_09 |  |  |  | Wrong number dialled by guard (False complaint) | CAT5 wiring/ RJ45 Connector problem
 |  |  | OTH_03 | OTH_11 |  |  |  | Customer end Electricity problem (ONT power off) | Customer not available/ Flat locked
 |  |  | OTH_04 | OTH_15 |  |  |  | Customer internal Wiring problem | Cable unplugged from device
 | NC_1 | Shifting\Fixing_Request | NC_11 | NC_71 | NC_81 |  |  | ONT box/Connection/ONT/Instrument/Wiring | MTNL complaint | Inquiry about Service & othes information
 | NC_2 | New_Connection_Request | [NAME] | NC_72 |  |  |  | Ducting/ Fiber/ ONT box fixing/ Splicing/ Configuration/ Migration / CaT5 wiring/ [NAME] installation/ I/O punching/ Airtel connections/ Instrument connection | Old Copper Complaint
 | NC_3 | QC\PM\Site_Visit | NC_31 | NC_73 |  |  |  | Quality check of new handed over society/ Preventive maintinance of the existing societies | Genset power connection
 | NC_4 | Parallel_Connection\Remigration | NC_41 |  |  |  |  | Parallel connection in room/ Remigrate the connection
 | NC_5 | ONT_Removed\Uninstallation | NC_51 |  |  |  |  | ONT removed form Flat
 | NC_6 | DBMS\Report_Update | NC_61 |  |  |  |  | Database update/ report update
 | NC_7 | Old_MTNL_Problem
 | NC_8 | Customer_Inquiry
 | OUT_1 | Planned_Outage | OUT_11 | [NAME] |  |  |  | Preventive maintenance | OSP ring outage
 | OUT_2 | Unplanned_Outage | OUT_12 | OUT_22 |  |  |  | Software Upgradation | [NAME]
 |  |  | OUT_13 | OUT_23 |  |  |  | System Modification | [NAME]
 |  |  | OUT_14 | OUT_24 |  |  |  | Testing perpose (R&D) | Fiber damage