{"id":897,"date":"2020-06-17T15:51:05","date_gmt":"2020-06-17T22:51:05","guid":{"rendered":"https:\/\/SUMMALAI.COM\/?p=897"},"modified":"2020-06-17T23:23:48","modified_gmt":"2020-06-18T06:23:48","slug":"create-new-worksheets-based-on-values-in-a-column","status":"publish","type":"post","link":"https:\/\/SUMMALAI.COM\/?p=897","title":{"rendered":"Create new worksheets based on values in a column"},"content":{"rendered":"\n

Step 1, download the excel add-on from here.<\/p>\n\n\n\n

DXL<\/a>Download<\/a><\/div>\n\n\n\n

Step 2, Unzip the file.<\/p>\n\n\n\n

Step 3, Open your spreadsheet on EXCEL.<\/p>\n\n\n\n

Step 4, Double click “DXL.xlam<\/strong>” to load the add-on.<\/p>\n\n\n\n

Step 5, Click “DataXL<\/strong>” on the top right and then Click “Ranges<\/strong>“, choose “Split Range into sheets<\/strong>” from the menu.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Step 6, Choose how many rows in the header and which column will be refereed for creating new tabs.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

All done.<\/p>\n\n\n\n

\"\"<\/figure>\n","protected":false},"excerpt":{"rendered":"

Step 1, download the excel add-on from here. Step 2, Unzip the file. Step 3, Open your spreadsheet on EXCEL. Step 4, Double click “DXL.xlam” to load the add-on. Step 5, Click “DataXL” on the top right and then Click “Ranges“, choose “Split Range into sheets” from the menu. Step 6, Choose how many rows Read More<\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[10,18],"tags":[143,144],"class_list":["post-897","post","type-post","status-publish","format-standard","hentry","category-microsoft","category-microsoft-office","tag-excel","tag-office"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=\/wp\/v2\/posts\/897","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=897"}],"version-history":[{"count":0,"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=\/wp\/v2\/posts\/897\/revisions"}],"wp:attachment":[{"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=897"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=897"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=897"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}