viewsonic165
04-03-2008, 10:14 AM
Hi,
Im trying to created a goalseek that will change values across a few workbooks...Is this possible? Here are the specifics:
In the summary workbook I want to be able to input a value of total wigets. This will cause multiple workbooks to goalseek a filter % that changes values for the number of widgets individual workbook such that the filter % in each workbook is equal and the total number of widgets across all workbooks equals the value inputed ont he summary workbook.
Thanks for the help
Im trying to created a goalseek that will change values across a few workbooks...Is this possible? Here are the specifics:
In the summary workbook I want to be able to input a value of total wigets. This will cause multiple workbooks to goalseek a filter % that changes values for the number of widgets individual workbook such that the filter % in each workbook is equal and the total number of widgets across all workbooks equals the value inputed ont he summary workbook.
Thanks for the help