Convert multiple tables from once currency to another

[mlambie327]

Hello,

I have a workbook that has multiple sheets that have tables in them with varying %'s of profits and their corresponding dollar amount. (Ex: 20% = $300, 30% = $400, etc...) These dollar amounts are not actual values in the cells but reference cells from a different workbook on our hard drive that contain the formula for determining our dollar values.

The issue I have is these tables and their dollar amounts are currently setup for Canadian Dollars and I need a quick and easy way to convert them into USD without adjusting each individual cell 1 by 1.

Any help would be much appreciated!

 

[ranman256]

1 col has CAN $,
1 col has USD, all based on 1 cell that has the exchange rate
label: CAN2US , then all rows upd upon new rate in cell