*Hi,* * * *Please attach some Data in Excel...* * * *Best Regards,* *Venkat * *Chennai* *My Linked in profile <http://in.linkedin.com/pub/venkatesan-c/21/492/a71>*
On Fri, Sep 9, 2011 at 2:04 AM, Jose Costa <zakk.co...@gmail.com> wrote: > 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
