planillero.com - Web site in english
English
planillero.cl - Sitio en español
Español
Examples of the use of Excel formulas with Macro Commands (VBA)
1) Update of UF 2010 values in Excel spreadsheet
Using Excel formulas it is possible to update a spreadsheet with historic values of a financial or stock index. In this example, UF (Unidad de Fomento) values are extracted for year 2010 directly to an Excel spreadsheet.
Source: www.sii.cl


2) Conversion of different currencies to Dollars or Euros in Excel spreadsheet
With automatic update through macro commands in Excel you will be able to obtain conversion values for 151 different currencies worldwide, to US Dollar or Euro.
Source: Sauder School of Business


3) Information search and comparisons
In this spreadsheet it has been programmed a macro command in Excel that is able to search and compare values among two sheets. The idea is to check whether the data in one sheet is found in the other and how many times it is repeated.
See further instructions in the attached spreadsheet.


4) Distances between 131 cities in Chile
The following spreadsheet contains information of distances between 131 cities in Chile, which are displayed in a double-entrance table. Using forms and macros programming (VBA), we are able to search for distances between different cities in Chile in a simple and direct way among the data table.


Contact us for spreadsheet optimization through macros

If you need further information about optimization services through macro commands in Excel (VBA), please contact us.

* This spreadsheets have a trial period of 10 days. After this period you can contact us to extend its validity.

planillero.com - Spreadsheet Outsourcing services