Multipe Goal Seek across workbooks

[viewsonic165]

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]

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...