When you have different files and need to extract data from them, but the only way you can do it is using excel formula, this is the app to go. This useful algorithm help users to extract data from up to 12 different excel files using any formula and and put the information in custom templates. Furthermore, save all the information extracted into a simple and clear data base.

1,500

Lines of code

Screenshots

Through the Main Sheet you can select each file and assign an Alias (so you can identify each file later with a custom name) and select if you want to execute and show the results in the template sheets.

In the Config sheet you can add the formula you need to execute in each file and can extract data from up to 5 different sheets at once, you need to indicate the template (in this case is EXAMPLE), the block and the row.

Also, you need to configure as many templates as you want and assign the position from where the extracted information will be printed. The use can print up to 10 different blocks (series of columns) per each row. Define the range whe data is going to be displayed and the headers that will be stored in the data base.

Give the name of the sheets from which the data will be extracted and create your own custom categories to store the data in the DB.

Download

Excel File: Download

Overview

Release date: November 2024

Finally, create as many templates as you need, this example illustrates how it can be done.