Dear dguille...@gmail.com,please be informed that spreadsheet is other name for work sheet.
On Sat, Sep 10, 2011 at 8:24 PM, dguillett1 <dguille...@gmail.com> wrote: > 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 <http://twitter.com/exceldailytip> > 2. Join our LinkedIN group @ > http://www.linkedin.com/**groups?gid=1871310<http://www.linkedin.com/groups?gid=1871310> > 3. Excel tutorials at > http://www.excel-macros.**blogspot.com<http://www.excel-macros.blogspot.com> > 4. Learn VBA Macros at > http://www.quickvba.blogspot.**com<http://www.quickvba.blogspot.com> > 5. Excel Tips and Tricks at > http://exceldailytip.blogspot.**com<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<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 <http://twitter.com/exceldailytip> > 2. Join our LinkedIN group @ > http://www.linkedin.com/**groups?gid=1871310<http://www.linkedin.com/groups?gid=1871310> > 3. Excel tutorials at > http://www.excel-macros.**blogspot.com<http://www.excel-macros.blogspot.com> > 4. Learn VBA Macros at > http://www.quickvba.blogspot.**com<http://www.quickvba.blogspot.com> > 5. Excel Tips and Tricks at > http://exceldailytip.blogspot.**com<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<http://www.facebook.com/discussexcel> > -- Regards Ram 9990484446/011-46087206 -- ---------------------------------------------------------------------------------- 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
