{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["data","Summit"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"data","index":0,"n_rows":22,"n_cols":7,"rows_kept":22,"cut":false,"hidden":false,"merged":[[12,0,12,1]]}
["Mobile no","Customer Name","Address 1","Town Name","SR Number","Created By"]
[7200229887,"PADMANI  T","96 PERAVOOR WARD 1 ILAMANOOR P , .","RAMANATHAPURAM","1-20243868767","EBINESAR_G"]
[7200581301,"MANI  S","NO 59 WARD 9HARIJAN COLONY KARUNAPURAMKALLAKURICHI","VILLUPURAM","1-20250269685","SILAMBARASAN_P"]
[7396043999,"VENU  ","add1",null,"1-20158907458","MURAHARI_JAIKUMAR"]
[7416263997,"NAGESH  ","add1",null,"1-20179673577","GUMMDALLI_BALAKISHORE"]
[7418164199,"NATARAJ  R","NNO 21/9KEPPAR MALAI ROADCUDDALORE TK","CUDDALORE","1-20130129500","NAVEENRAJ_M"]
[7418674722,"SUJANACHARAN SWAIN J","NO 63THIYAGARAYA ROADPONDY BAZAAR T NAGAR","CHENNAI","1-20087075970","MAHA_LAKSHMY01"]
[7502455531,"SHEKI OAJITH BEAGUNM S","NO 3 RD MANI NO 1880 MIG MMDA MATHUR ROAD CHENNAI","CHENNAI","1-20246090278","MAHA_LAKSHMY01"]
[7502783264,"KANNAPIRAN  V","NO88 WARD 2SATHAMPADI ROADSIRUTHALAIPOONDI","VILLUPURAM","1-20117858186","UMAYA_PANDI"]
[7569748569,"RAJU  ","add1",null,"1-20118564229","GUMMDALLI_BALAKISHORE"]
[7569749306,"VENKATESH  ","add1",null,"1-20114273980","SAMARNATH_MANDAL"]
[]
["Please help in creating tracker form"]
[]
["All the data base which are given above is to be reflected in the user form.  And if we select customer name or mobile number then the corresponding details such as- address1, Town name, SR Number, Created By- should show in the form. ","I have provided some sample in the Form tracker, please find that.",null,"And in the New data entry form (inside the form) , IF we wish to fill a new data base, then we have the option for filling data. And if we give summit button , the base should store in the data base which is left hand side of form, and the new entry data should save in Summit sheet.","eg: customer name-abcd, number:-123456, and address:-xyz, so on, after filling those data, if we give summit button, the information should save in Summit sheet.",null,"Thanks experts !!, for creating such a coperative and helful groups in excelgroups, thanks …"]
[]
["Thank you very much for done."]
[]
["I have added one button called Traced data, in that form if we click customer name or customer number, the corresponding customer data should reflect."]
["can you please help in creating that."]
["eg.- if enter customer-NATARAJ  R then his mobile number should reflect in (enter mobile no.) and should should reflect in address, sr number, and creadted by."]
["in additional, if possible what ever data is there in the summit sheet should automatically reflect in the form. Traced data."]

{"sheet":"Summit","index":1,"n_rows":13,"n_cols":6,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["Mobile no","Customer Name","Address 1","Town Name","SR Number","Created By"]
[7200229887,"PADMANI  T","96 PERAVOOR WARD 1 ILAMANOOR P , .","RAMANATHAPURAM","1-20243868767","EBINESAR_G"]
[7200581301,"MANI  S","NO 59 WARD 9HARIJAN COLONY KARUNAPURAMKALLAKURICHI","VILLUPURAM","1-20250269685","SILAMBARASAN_P"]
[7396043999,"VENU  ","add1",null,"1-20158907458","MURAHARI_JAIKUMAR"]
[7416263997,"NAGESH  ","add1",null,"1-20179673577","GUMMDALLI_BALAKISHORE"]
[7418164199,"NATARAJ  R","NNO 21/9KEPPAR MALAI ROADCUDDALORE TK","CUDDALORE","1-20130129500","NAVEENRAJ_M"]
[7418674722,"SUJANACHARAN SWAIN J","NO 63THIYAGARAYA ROADPONDY BAZAAR T NAGAR","CHENNAI","1-20087075970","MAHA_LAKSHMY01"]
[7502455531,"SHEKI OAJITH BEAGUNM S","NO 3 RD MANI NO 1880 MIG MMDA MATHUR ROAD CHENNAI","CHENNAI","1-20246090278","MAHA_LAKSHMY01"]
[7502783264,"KANNAPIRAN  V","NO88 WARD 2SATHAMPADI ROADSIRUTHALAIPOONDI","VILLUPURAM","1-20117858186","UMAYA_PANDI"]
[7569748569,"RAJU  ","add1",null,"1-20118564229","GUMMDALLI_BALAKISHORE"]
[7569749306,"VENKATESH  ","add1",null,"1-20114273980","SAMARNATH_MANDAL"]
[9769855615,"Anil Narayan","Ambernath","Adoni","1-558616","Gawli Anil"]
["KJHKHJ","KJHKJH","JHKHJK","KJHKHJ","KHJK","KHJK"]