Multiple Selections in different List Boxes

[#1]

Hi all!

is it possible to select multiple values from different list boxes, and then calculate these all together?

The problem is, loading a new selection takes quite a time, so it would be great if there was a way to condense this.

Example:

     Before:

          Select A and B from box 1 ... takes some time to recalculate sheet.

          C from box 2 ... recalculate sheet.

          D from box 3 .. recalculate sheet.

     What I hope to reach:

          Select A and B and C and D  ... calculate sheet only once.

Hope my concern is clear.

Thank you very much in advance!

Best regards

Ludwig

[rajeshvaswani77]

Hi,

If you can create a table at script level with all combinations, having the results. There would be no re-calculation time involved.

thanks,

Rajesh Vaswani

[#3]

I'm sorry but I don't really get your point  there.

Could you explain what you mean?

Thanks!