Please give clear before/after examples and how you get from before to
after.
Be advised that
a file is called a workbook
a sheet within a workbook is called a sheet or worksheet.
There is NO such term as SPREADSHEET
-----Original Message-----
From: Jose Costa
Sent: Thursday, September 08, 2011 3:34 PM
To: MS EXCEL AND VBA MACROS
Subject: $$Excel-Macros$$Read column(s) and calculate currency on multiple
target spreadsheets/worksheets
Hi all,
I'm trying to build an Excel solution that would do the following:
- User select a given spreadsheet/worksheet/column(sample below),
where file location may vary and exchange rate column will vary (based
on Month)
- Allows target selection:
User selects target spreadsheet(s) and worksheet(s) within
spreadsheet(s)
User selects currency and amount columns for each worksheet/
spreadsheet
User defines target rates (CAD and USD) into target columns
(e.g. CAD @ G, USD @ I)
Logic converts values and writes to target columns
Currency Name Currency Code Base Rate Nov10 Dec10 Jan11
UNITED STATES DOLLARS USD CAD 1.026115 0.997437 1.001006
ALGERIA DINARS DZD CAD 0.013764 0.013383 0.013726
ALGERIA DINARS DZD USD 0.013414 0.013417 0.013712
ARGENTINA PESOS ARS CAD 0.257947 0.251244 0.249783
ARGENTINA PESOS ARS USD 0.251383 0.251889 0.249532
ARUBA GUILDERS AWG CAD 0.573249 0.557227 0.559221
ARUBA GUILDERS AWG USD 0.558659 0.558659 0.558659
AUSTRALIA DOLLARS AUD CAD 0.984433 1.019336 0.997949
AUSTRALIA DOLLARS AUD USD 0.959379 1.021956 0.996946
BAHAMAS DOLLARS BSD CAD 1.026115 0.997437 1.001006
BAHAMAS DOLLARS BSD USD 1.000000 1.000000 1.000000
BAHRAIN DINARS BHD CAD 2.721465 2.645160 2.655154
BAHRAIN DINARS BHD USD 2.652203 2.651957 2.652485
BANGLADESH TAKA BDT CAD 0.014586 0.014118 0.014139
Can you help?
Thanks in advance!
JC
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
