{"id":9523,"date":"2021-12-01T16:48:24","date_gmt":"2021-12-01T16:48:24","guid":{"rendered":"https:\/\/lgildv5i97.onrocket.site\/answers\/?post_type=question&#038;p=9523"},"modified":"2021-12-01T16:50:27","modified_gmt":"2021-12-01T16:50:27","slug":"macro-save-mult-wrkbks-based-on-dropdown","status":"publish","type":"question","link":"https:\/\/computing.net\/answers\/office\/macro-save-mult-wrkbks-based-on-dropdown\/10095.html","title":{"rendered":"Macro- Save Mult. Wrkbks Based On Dropdown"},"content":{"rendered":"<p>Hi there,<\/p>\n<p>I have one spreadsheet with a drop down of roughly 200 names (dropdown in cell H5), each selection then populates other data based on the dropdown. I need to create an individual workbook for each of the items in the dropdown.<br \/>\nExample:<br \/>\nH5(List of names in drop down)<br \/>\nBob<br \/>\nSue<br \/>\nConnie<\/p>\n<p>I would open my master workbook, select &#8220;bob,&#8221; then &#8216;Save as&#8217; &#8220;Bob.&#8221; Move on to next name. select &#8220;Sue,&#8221; &#8216;Save as&#8217; &#8220;Sue&#8221;, move on&#8230; Is there a macro that can do this for me?<br \/>\nIf so, can I have the file name be 2 cells put together? Each name has a number that is attached (like an employee number), when that persons name is selected the number automatically pops up in cell H7 using a VLookup. Can the Macro save each file name based on the data located in 2 cells? IE-<br \/>\nH5- Sue<br \/>\nH7- 11<br \/>\nFile Name: 11-Sue<\/p>\n<p>Suggestions?<\/p>\n","protected":false},"author":5,"featured_media":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"inline_featured_image":false,"iawp_total_views":3},"question-category":[53],"question_tags":[],"class_list":["post-9523","question","type-question","status-publish","hentry","question-category-office"],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/question\/9523","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/question"}],"about":[{"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/types\/question"}],"author":[{"embeddable":true,"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/comments?post=9523"}],"wp:attachment":[{"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/media?parent=9523"}],"wp:term":[{"taxonomy":"question-category","embeddable":true,"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/question-category?post=9523"},{"taxonomy":"question_tags","embeddable":true,"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/question_tags?post=9523"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}