Hi,

Hope someone can help me solve this.

I would like to create a 'Source Currency' worksheet that is used as the data source for calculations in another worksheet called Option 1.

Upon the Source Currency worksheet I would like to have a data validation list of different currencies. Each currency in the data validation list, when selected, would copy the entire contents for that currency from another hidden worksheet.

Each hidden currency worksheet has the exact same structure except the data in each cell is in the specific currency.

Any help would be greatly appreciated.

Thanks,
martin