Hi Folks - Here's my situation. I have to convert local currencies into
dollars based on a conversion rate. The conversion rate changes a few times
per year. So, my sheet looks like this:

Value in Local Currency Local Currency Value in Dollars

100,000 HK 75,000
200,000 DHS 175,000


For instance, say the rate for HK conversions is .55 effective 1/1/2005. So,
I have many HK conversion transactions based on that rate. (I use a lookup
to determine what currency to convert and what rate to use). Now, on
7/1/2005, the rate changes to .65. If I change the rate in my lookup table,
then all transactions from 1/1/2005 will change. I need way to preserve the
rate conversions from 1/1/2005 through 6/30/2005. Any ideas?

Thanks.

Michael