Excel Examples

 

- Excel Autoamtic Reports

- Excel Importer

 

Excel Autoamtic Reports  
You load a report or a table, full of information, directly from your ERP system or from any other application. This database is usually raw with lack of managerial view. What shall you do?

You should open a new excel file. One worksheet is dedicated for the database. Another worksheet is designed to have a managerial view based on this database. This view includes summary reports, quick indications, graphs and much more. Once you load a new table and copy it into the excel file, the reports are updated automatically.

To demonstrate this process, you may download Excel Automatic Reports (remember to enable VBA).

Excel Importer  
This Excel application has the ability to import information from many excel files into one Master Excel File.
Example: you have many excel files; each represents a form or a questionnaire for a different individual. Now, you may gather all the relevant data, from all worksheets, in a one table, organized according to your database definitions.

 

The Excel Master File has a worksheet name ‘master’. This worksheet has 4 columns. See example:

 

Imported File			Current File
Path	Worksheet	Cell	Worksheet	Cell
C:\files\1.xls	Table1	B13	Data	A2
C:\files\1.xls	Table2	D56	Data	B2
C:\files\2.xls	Table1	A2	Data	C2

 To demonstrate this process, you may download Excel Importer Demo.