{"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":"

<\/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

XLEV8 EXCEL PRODUCT MANUAL<\/span><\/h1>\n
\u00a0<\/p>\n
BULK GOAL SEEK<\/h2>\n
[\/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
What it does<\/strong><\/span>
Uses a settings sheet (Bulk_Goal_Seek<\/strong><\/span>) to run multiple goal seek calculations in succession, in one bulk step.<\/p>\n
When to use it<\/strong><\/span>
When you want to quickly process multiple goal seek calculations in the same file in one bulk step.<\/p>\n
Why to use it<\/strong><\/span>
It\u2019s much quicker and easier than running multiple goal seek calculations one at a time.<\/p>\n
Default shortcut<\/strong><\/span>
None<\/p>\n
Other Details<\/strong><\/span><\/p>\n
\n
Category: Data \/ Content<\/li>\n
Difficulty: 2\/5<\/li>\n
Usage\/frequency: 2\/5<\/li>\n
Automation factor: 5\/5 (estimated 180 seconds saved each time used)<\/li>\n
Type: Bulk<\/li>\n
Date added: 9\/18\/2023<\/li>\n
Tags: goal seek, bulk<\/li>\n<\/ul>\n
[\/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
Related Macros<\/strong>
None<\/p>\n
Other Articles<\/strong>
None<\/p>\n
[\/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
Bulk Goal Seek Example File<\/a><\/p>\n
[\/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
Prerequisites<\/strong>
Identify the goal seek sources and result targets you want to run for.<\/p>\n
Instructions
<\/strong>After you have identified the goal seek sources and result targets to run for, run the Bulk Goal Seek<\/strong>\u00a0macro.\u00a0 The first time you run it, it will create a sheet called 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 Bulk Goal Seek<\/strong> macro again to process the contents.\u00a0 These are the fields in the Bulk_Goal_Seek<\/strong><\/span> sheet that you\u2019ll want to fill in:<\/p>\n
\n
Column A \u2013 Goal seek sheet<\/strong> (required): enter the name of the sheet containing the range to apply goal seek on.<\/li>\n
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
Column C \u2013 Range goal value<\/strong> (required) \u2013 enter (or reference) the range goal value you are seeking.<\/li>\n
Column D \u2013 Change sheet<\/strong> (required) \u2013 enter the name of the sheet containing the range to change.<\/li>\n
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
[\/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
\n
$\"\"$
Screenshot of Bulk Goal Seek macro.<\/p><\/div>\n<\/div>\n
[\/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>","protected":false},"excerpt":{"rendered":"
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,"footnotes":""},"class_list":["post-30898","page","type-page","status-publish","hentry"],"aioseo_notices":[],"aioseo_head":"\n\t\t\n\t\n\t\n\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t