{"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":[],"aioseo_head":"\n\t\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\t