Hi Venkat, Thanks for your quick reply.
I'm new to the group and couldn't find any option to attach files. Jose On Sep 9, 3:15 am, Venkat CV <venkat1....@gmail.com> wrote: > *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 athttp://www.excel-macros.blogspot.com > > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com > > 5. Excel Tips and Tricks athttp://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 > > -- > * > * > * > * > * > *- Hide quoted text - > > - Show quoted text - -- ---------------------------------------------------------------------------------- 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
