menu
Daily Bits Email

The email you entered is already receiving Daily Bits Emails!

MT Data Entry AssistantDiscount

MT Data Entry Assistant

SPEED-UP DATA ENTRY TASKS IN EXCEL

$15
v1.1 for PC 
Platforms: Windows (All) + Microsoft Office 2010 or Higher (32 and 64 Bits)
MT Data Entry Assistant ScreenshotExcel Add-ins Software ScreenshotMT Data Entry Assistant, Excel Add-ins Software ScreenshotMT Data Entry Assistant, Business & Finance Software ScreenshotExcel Add-ins Software, MT Data Entry Assistant Screenshot

MT Data Entry Assistant is an Add-In for Microsoft Excel that adds three powerful features designed to speed-up your data entry tasks.

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.

Review Written by Derek Lee
The Conversation
Features
The Fine Print
Expand All Email Updates Load 16 Older Comments
Todd User I purchased both MT for Worksheets and MT Data Entry Assistant earlier tonight. I liked them both very much, and tried to purchase a second license of each product. But the Fastspring system refuses my second orders. I have tried at least 10 times, and tried using different bank cards, logging in from different IP addresses, and even tried changing to a different name and email address... all attempts are refused without explanation. It is very strange. I don't believe the problem can be on my end. If you could look into this, it would be appreciated.
thanks
Dec 1 2015 at 11:01pm Copy Link
0

On BitsDuJour Today

Quicken WillMaker & Trust 2020 (Mac & PC) Discount
Mac & PC
Quicken WillMaker & Trust 2020
Create Your Estate Plan Easily
50
Performance Management For Dummies ($19.99 Value) FREE for a Limited Time (Mac & PC) Discount
Mac & PC
Performance Management For Dummies ($19.99 Value) FREE for a Limited Time
Implement best-in-class performance management systems.
100
iMyfone iTransor (Mac & PC) Discount
Mac & PC
iMyfone iTransor
Export Data from iOS, iTunes Backups, and iCloud
79

Excel Add-ins Deals

PrintableCal Premium (PC) Discount
for PC
PrintableCal Premium
Create Printable Calendars in Word and Excel
Add Data To Multiple Excel Cells (PC) Discount
for PC
Add Data To Multiple Excel Cells
Make Sweeping Changes To Your Excel Spreadsheets!
inspector text (PC) Discount
for PC
inspector text
Powerful Text Editing in Excel
ESharper (PC) Discount
for PC
ESharper
Add User Defined Functions to Excel Using C#
Like BitsDuJour on Facebook
BitsDuJour is for People who Love Software
Every day we review great Mac & PC apps, and get you discounts up to 100%
© Copyright 2020 BitsDuJour LLC. Code & Design. All Rights Reserved. Privacy Policy