Changing a Worksheet Reference Formula using a drop down box
 

Hi

I have identical data sets in different worksheets. I have one calculation
worksheet at the front of the workbook and based upon the choice in a drop
down box I want the calculation sheet to reference one of the different data
sets.

I have tried using IF statements and this is ok until you reach 7 worksheets.

Is there a way where I can change the referenced worksheet in the
calculation formulae based upon the choice made in the drop down box?

Any help much appreciated.

Best regards
Dave

Changing a Worksheet Reference Formula using a drop down box
 

Hi Dave,

Use the INDIRECT() function.
Look in HELP for details

--
Kind regards,

Niek Otten

"DaveyC4S" wrote in message
...
Hi

I have identical data sets in different worksheets. I have one
calculation
worksheet at the front of the workbook and based upon the choice in a drop
down box I want the calculation sheet to reference one of the different
data
sets.

I have tried using IF statements and this is ok until you reach 7
worksheets.

Is there a way where I can change the referenced worksheet in the
calculation formulae based upon the choice made in the drop down box?

Any help much appreciated.

Best regards
Dave