Re: $$Excel-Macros$$Read column(s) and calculate currency on multiple target spreadsheets/worksheets

2011-09-11 Thread dguillett1 
Some do use that terminology but there is less confusion if it is VERY clear.
A “Spreadsheet” can be the range of work on a sheet (other than worksheet such 
as chart) or worksheet. 
When asking for help the poster should make sure that the person offering the 
help understands what is needed.

From: R Swarup 
Sent: Saturday, September 10, 2011 12:20 PM
To: excel-macros@googlegroups.com 
Subject: Re: $$Excel-Macros$$Read column(s) and calculate currency on multiple 
target spreadsheets/worksheets

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  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.00 1.00 1.00
  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




-- 
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 lin

Re: $$Excel-Macros$$Read column(s) and calculate currency on multiple target spreadsheets/worksheets

2011-09-10 Thread R Swarup 
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  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.00 1.00 1.00
> 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

Re: $$Excel-Macros$$Read column(s) and calculate currency on multiple target spreadsheets/worksheets

2011-09-10 Thread dguillett1 
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.00 1.00 1.00
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

Re: $$Excel-Macros$$Read column(s) and calculate currency on multiple target spreadsheets/worksheets

2011-09-09 Thread Venkat CV 
Hi  Jose,

Just go to your Gmail and Compose Mail and send it to *
excel-macros@googlegroups.com * and it will Automatically Reach Group.. You
can attach your file in Gmail itself..



On Fri, Sep 9, 2011 at 6:15 PM, Jose Costa  wrote:

> 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  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  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.0261150.997437
> > >  1.001006
> > > ALGERIA DINARS  DZD CAD 0.0137640.013383
>  0.013726
> > > ALGERIA DINARS  DZD USD 0.0134140.013417
>  0.013712
> > > ARGENTINA PESOS ARS CAD 0.2579470.251244
>  0.249783
> > > ARGENTINA PESOS ARS USD 0.2513830.251889
>  0.249532
> > > ARUBA GUILDERS  AWG CAD 0.5732490.557227
>  0.559221
> > > ARUBA GUILDERS  AWG USD 0.5586590.558659
>  0.558659
> > > AUSTRALIA DOLLARS   AUD CAD 0.9844331.019336
> > >  0.997949
> > > AUSTRALIA DOLLARS   AUD USD 0.9593791.021956
> > >  0.996946
> > > BAHAMAS DOLLARS BSD CAD 1.0261150.997437
>  1.001006
> > > BAHAMAS DOLLARS BSD USD 1.001.00
>  1.00
> > > BAHRAIN DINARS  BHD CAD 2.7214652.645160
>  2.655154
> > > BAHRAIN DINARS  BHD USD 2.6522032.651957
>  2.652485
> > > BANGLADESH TAKA BDT CAD 0.0145860.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
>



-- 
*Best Regards,*
*Venkat *
*Chennai*
*My Linked in profile *
*
*
*
*

-- 
--
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

Re: $$Excel-Macros$$Read column(s) and calculate currency on multiple target spreadsheets/worksheets

2011-09-09 Thread Jose Costa 
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  wrote:
> *Hi,*
> *
> *
> *Please attach some Data in Excel...*
> *
> *
> *Best Regards,*
> *Venkat *
> *Chennai*
> *My Linked in profile *
>
>
>
>
>
> On Fri, Sep 9, 2011 at 2:04 AM, Jose Costa  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.00        1.00        1.00
> > 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

Re: $$Excel-Macros$$Read column(s) and calculate currency on multiple target spreadsheets/worksheets

2011-09-09 Thread Venkat CV 
*Hi,*
*
*
*Please attach some Data in Excel...*
*
*
*Best Regards,*
*Venkat *
*Chennai*
*My Linked in profile *

On Fri, Sep 9, 2011 at 2:04 AM, Jose Costa  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.0261150.997437
>  1.001006
> ALGERIA DINARS  DZD CAD 0.0137640.0133830.013726
> ALGERIA DINARS  DZD USD 0.0134140.0134170.013712
> ARGENTINA PESOS ARS CAD 0.2579470.2512440.249783
> ARGENTINA PESOS ARS USD 0.2513830.2518890.249532
> ARUBA GUILDERS  AWG CAD 0.5732490.5572270.559221
> ARUBA GUILDERS  AWG USD 0.5586590.5586590.558659
> AUSTRALIA DOLLARS   AUD CAD 0.9844331.019336
>  0.997949
> AUSTRALIA DOLLARS   AUD USD 0.9593791.021956
>  0.996946
> BAHAMAS DOLLARS BSD CAD 1.0261150.9974371.001006
> BAHAMAS DOLLARS BSD USD 1.001.001.00
> BAHRAIN DINARS  BHD CAD 2.7214652.6451602.655154
> BAHRAIN DINARS  BHD USD 2.6522032.6519572.652485
> BANGLADESH TAKA BDT CAD 0.0145860.0141180.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

$$Excel-Macros$$Read column(s) and calculate currency on multiple target spreadsheets/worksheets

2011-09-08 Thread Jose Costa 
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.0261150.9974371.001006
ALGERIA DINARS  DZD CAD 0.0137640.0133830.013726
ALGERIA DINARS  DZD USD 0.0134140.0134170.013712
ARGENTINA PESOS ARS CAD 0.2579470.2512440.249783
ARGENTINA PESOS ARS USD 0.2513830.2518890.249532
ARUBA GUILDERS  AWG CAD 0.5732490.5572270.559221
ARUBA GUILDERS  AWG USD 0.5586590.5586590.558659
AUSTRALIA DOLLARS   AUD CAD 0.9844331.0193360.997949
AUSTRALIA DOLLARS   AUD USD 0.9593791.0219560.996946
BAHAMAS DOLLARS BSD CAD 1.0261150.9974371.001006
BAHAMAS DOLLARS BSD USD 1.001.001.00
BAHRAIN DINARS  BHD CAD 2.7214652.6451602.655154
BAHRAIN DINARS  BHD USD 2.6522032.6519572.652485
BANGLADESH TAKA BDT CAD 0.0145860.0141180.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