{"id":30898,"date":"2023-11-14T03:39:15","date_gmt":"2023-11-14T03:39:15","guid":{"rendered":"https:\/\/excelevate.co\/wp\/?page_id=30898"},"modified":"2023-11-14T03:39:16","modified_gmt":"2023-11-14T03:39:16","slug":"xlev8-manual-bulk-goal-seek","status":"publish","type":"page","link":"https:\/\/excelevate.co\/wp\/home\/support\/xlev8-manual-bulk-goal-seek\/","title":{"rendered":"XLEV8 MANUAL: BULK GOAL SEEK"},"content":{"rendered":"<body><p><\/p>[et_pb_section fb_built=\u201d1\u2033 _builder_version=\u201d4.16\u2033 _module_preset=\u201ddefault\u201d custom_padding=\u201d0px|||||\u201d global_colors_info=\u201d{}\u201d][et_pb_row _builder_version=\u201d4.16\u2033 _module_preset=\u201ddefault\u201d global_colors_info=\u201d{}\u201d][et_pb_column type=\u201d4_4\u2033 _builder_version=\u201d4.16\u2033 _module_preset=\u201ddefault\u201d global_colors_info=\u201d{}\u201d][et_pb_text _builder_version=\u201d4.17.6\u2033 _module_preset=\u201ddefault\u201d min_height=\u201d28.8px\u201d global_colors_info=\u201d{}\u201d]\n<h1 style=\"text-align: center;\"><img data-recalc-dims=\"1\" decoding=\"async\" src=\"https:\/\/i0.wp.com\/excelevate.co\/wp\/wp-content\/uploads\/2020\/10\/read_icon_green_transparent.png?w=30&#038;ssl=1\"  style=\"vertical-align: middle;\" loading=\"lazy\"> <span style=\"vertical-align: middle;\">XLEV8 EXCEL PRODUCT MANUAL<\/span><\/h1>\n<p>\u00a0<\/p>\n<h2 style=\"text-align: center;\">BULK GOAL SEEK<\/h2>\n<p>[\/et_pb_text][et_pb_toggle title=\u201dDetails\u201d _builder_version=\u201d4.17.6\u2033 _module_preset=\u201ddefault\u201d global_colors_info=\u201d{}\u201d]<\/p>\n<p><span style=\"font-size: medium;\"><strong>What it does<\/strong><\/span><br>Uses a settings sheet (<span style=\"color: #2ca021;\"><strong>Bulk_Goal_Seek<\/strong><\/span>) to run multiple goal seek calculations in succession, in one bulk step.<\/p>\n<p><span style=\"font-size: medium;\"><strong>When to use it<\/strong><\/span><br>When you want to quickly process multiple goal seek calculations in the same file in one bulk step.<\/p>\n<p><span style=\"font-size: medium;\"><strong>Why to use it<\/strong><\/span><br>It\u2019s much quicker and easier than running multiple goal seek calculations one at a time.<\/p>\n<p><span style=\"font-size: medium;\"><strong>Default shortcut<\/strong><\/span><br>None<\/p>\n<p><span style=\"font-size: medium;\"><strong>Other Details<\/strong><\/span><\/p>\n<ul>\n<li>Category: Data \/ Content<\/li>\n<li>Difficulty: 2\/5<\/li>\n<li>Usage\/frequency: 2\/5<\/li>\n<li>Automation factor: 5\/5 (estimated 180 seconds saved each time used)<\/li>\n<li>Type: Bulk<\/li>\n<li>Date added: 9\/18\/2023<\/li>\n<li>Tags: goal seek, bulk<\/li>\n<\/ul>\n<p>[\/et_pb_toggle][et_pb_toggle title=\u201dRelated Macros and Articles\u201d _builder_version=\u201d4.17.6\u2033 _module_preset=\u201ddefault\u201d global_colors_info=\u201d{}\u201d]<\/p>\n<p><strong>Related Macros<\/strong><br>None<\/p>\n<p><strong>Other Articles<\/strong><br>None<\/p>\n<p>[\/et_pb_toggle][et_pb_toggle title=\u201dExample Files\u201d _builder_version=\u201d4.17.6\u2033 _module_preset=\u201ddefault\u201d global_colors_info=\u201d{}\u201d]<\/p>\n<p><a href=\"https:\/\/excelevate.co\/wp\/wp-content\/uploads\/2023\/11\/Bulk-Goal-Seek_Example-File_2023-11-13.xlsx\">Bulk Goal Seek Example File<\/a><\/p>\n<p>[\/et_pb_toggle][et_pb_toggle title=\u201dInstructions\u201d _builder_version=\u201d4.18.0\u2033 _module_preset=\u201ddefault\u201d global_colors_info=\u201d{}\u201d]<\/p>\n<p><strong>Prerequisites<\/strong><br>Identify the goal seek sources and result targets you want to run for.<\/p>\n<p><strong>Instructions<br><\/strong>After you have identified the goal seek sources and result targets to run for, run the <strong>Bulk Goal Seek<\/strong>\u00a0macro.\u00a0 The first time you run it, it will create a sheet called <span style=\"color: #2ca021;\"><strong>Bulk_Goal_Seek<\/strong><\/span>.\u00a0 This is where you\u2019ll specify the goal seek sheets, ranges, and goal values.\u00a0 After filling in the values, run the <strong>Bulk Goal Seek<\/strong> macro again to process the contents.\u00a0 These are the fields in the <span style=\"color: #2ca021;\"><strong>Bulk_Goal_Seek<\/strong><\/span> sheet that you\u2019ll want to fill in:<\/p>\n<ul>\n<li><strong>Column A \u2013 Goal seek sheet<\/strong> (required): enter the name of the sheet containing the range to apply goal seek on.<\/li>\n<li><strong>Column B \u2013 Goal seek range<\/strong> (required) \u2013 enter the range address\/name to apply goal seek on (the target\/result containing a formula).\u00a0 Note if entering a range name, the range name must only contain one cell.<\/li>\n<li><strong>Column C \u2013 Range goal value<\/strong> (required) \u2013 enter (or reference) the range goal value you are seeking.<\/li>\n<li><strong>Column D \u2013 Change sheet<\/strong> (required) \u2013 enter the name of the sheet containing the range to change.<\/li>\n<li><strong>Column E \u2013 Change range<\/strong> (required) \u2013 enter the range address\/name to change.\u00a0 Note if entering a range name, the range name must only contain one cell.<\/li>\n<\/ul>\n<p>[\/et_pb_toggle][et_pb_toggle title=\u201dScreenshots\u201d _builder_version=\u201d4.23.1\u2033 _module_preset=\u201ddefault\u201d hover_enabled=\u201d0\u2033 global_colors_info=\u201d{}\u201d sticky_enabled=\u201d0\u2033]<\/p>\n<div style=\"text-align: center;\">\n<div id=\"attachment_27196\" style=\"width: 1034px\" class=\"wp-caption aligncenter\"><img data-recalc-dims=\"1\" decoding=\"async\" aria-describedby=\"caption-attachment-27196\" src=\"https:\/\/i0.wp.com\/excelevate.co\/wp\/wp-content\/uploads\/2023\/11\/Bulk-Goal-Seek-Screenshot_2023-11-13.png?resize=1024%2C576&#038;ssl=1\" width=\"1024\" height=\"576\" alt=\"\" class=\"wp-image-27196 size-large\" style=\"display: block; margin-left: auto; margin-right: auto; text-align: center;\" loading=\"lazy\"><p id=\"caption-attachment-27196\" class=\"wp-caption-text\">Screenshot of Bulk Goal Seek macro.<\/p><\/div>\n<\/div>\n<p>[\/et_pb_toggle][et_pb_toggle title=\u201dVideo\u201d _builder_version=\u201d4.21.0\u2033 _module_preset=\u201ddefault\u201d global_colors_info=\u201d{}\u201d]None[\/et_pb_toggle][et_pb_comments _builder_version=\u201d4.17.6\u2033 _module_preset=\u201ddefault\u201d global_colors_info=\u201d{}\u201d][\/et_pb_comments][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n<\/body><span class=\"et_bloom_bottom_trigger\"><\/span>","protected":false},"excerpt":{"rendered":"<p>XLEV8 Add-in how to: Bulk Goal Seek<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":299,"menu_order":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"_et_pb_use_builder":"on","_et_pb_old_content":"","_et_gb_content_width":"","_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"class_list":["post-30898","page","type-page","status-publish","hentry"],"aioseo_notices":[],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/excelevate.co\/wp\/wp-json\/wp\/v2\/pages\/30898","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/excelevate.co\/wp\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/excelevate.co\/wp\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/excelevate.co\/wp\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/excelevate.co\/wp\/wp-json\/wp\/v2\/comments?post=30898"}],"version-history":[{"count":2,"href":"https:\/\/excelevate.co\/wp\/wp-json\/wp\/v2\/pages\/30898\/revisions"}],"predecessor-version":[{"id":30903,"href":"https:\/\/excelevate.co\/wp\/wp-json\/wp\/v2\/pages\/30898\/revisions\/30903"}],"up":[{"embeddable":true,"href":"https:\/\/excelevate.co\/wp\/wp-json\/wp\/v2\/pages\/299"}],"wp:attachment":[{"href":"https:\/\/excelevate.co\/wp\/wp-json\/wp\/v2\/media?parent=30898"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}