PDA

View Full Version : Multipe Goal Seek across workbooks



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

rbrhodes
04-03-2008, 09:09 PM
hi view,

It isn't really clear to me what you desire. Could you post a small example of what you mean? Before /After kind of thing...