Hi there,
I made a workbook of several spreadsheets. I have input data on 2 sheets. I'd like to use the scenario feature to change data on both sheets. I tried but Excel basically says that the reference sheet (where I change the data) must be unique.
How can I overcome this?
Thanks. Not urgent.
This message was edited by fred on 2002-04-15 07:41
I made a workbook of several spreadsheets. I have input data on 2 sheets. I'd like to use the scenario feature to change data on both sheets. I tried but Excel basically says that the reference sheet (where I change the data) must be unique.
How can I overcome this?
Thanks. Not urgent.
This message was edited by fred on 2002-04-15 07:41