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