MT Data Entry Assistant [for PC]

MT Data Entry Assistant is an add-in for Excel that will help you speed-up data entry tasks. It contains three powerful features:

Coordinates

Quite often, is necessary to work with tables with a large number of rows and columns in Excel. For example, imagine that you are working on a data table which has columns from A to Z and rows from 1 to 100 and you want to match F with 87 and check or modify this value. This tool can help you to do that in a matter of seconds, you just need to select the cell that is in the top left corner of your table (where the rows and columns start) and click on the Coordinates button, then you will see two drop-down lists (rows and columns of the table) where you can match any row with any columns and check or modify the resulting value.

Horizontal Filling

This tool focuses on the automatic filling of tables. For example, imagine that you need to fill a customers data table, this table has 300 rows (each row is a client) and 15 columns of information such as telephone number, address, email, ID, etc. So based on the name of your customers (rows) you have to enter data in columns, doing it manually would take a long time and it’s also a laborious task.In order to fill such table using this add-in, first you need to select the headers of your table and then click on the Horizontal Filling button, then select the main column (in this case ‘customers’) and which data you want to fill in (in this case ‘telephone number’, ‘address’, ‘email’…). Finally just enter the name of the customer and the data, click on Next button and the add-in will search the customer and fill the data in the corresponding columns. This process can be repeated many times using the keyboard only.

Vertical Filling

This tool works exactly like the previous one, but in this case you can fill tables from the rows instead of the columns, which means that you can fill the transposed table of the previous example. In order to fill such table using this add-in, first you need to select the vertical headers of your table and then click on the Vertical Filling button, then select the main column (in this case ‘customers’) and which data you want to fill in (in this case ‘telephone number’, ‘address’, ‘email’…). Finally just enter the name of the customer and the data, click on Next button and the add-in will search the customer and fill the data in the corresponding rows. This process can be repeated many times using the keyboard only.