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

DeltaWalker 2 (Mac & PC) Discount
Mac & PC
DeltaWalker 2
Sync, Compare, Edit, and Merge Files -- Intuitively and Gracefully!
50
Get almost any course for $11.99 (Mac & PC) Discount
Mac & PC
Get almost any course for $11.99
Only $11.99 Gets You a Complete Udemy Course
94

Excel Add-ins Deals

Spreadspeed (PC) Discount
for PC
Spreadspeed
Reduce Spreadsheet Errors, Get More Done
50
Pop-up Excel Calendar (PC) Discount
for PC
Pop-up Excel Calendar
An Easy Date Picker for Microsoft Excel
Dose for Excel Add-In (PC) Discount
for PC
Dose for Excel Add-In
Become More Productive in Microsoft Excel
40
FlowBreeze (PC) Discount
for PC
FlowBreeze
Do it, Flow Chart it, Improve it
Excel Auto Spreadsheet Backup Software (PC) Discount
for PC
Excel Auto Spreadsheet Backup Software
Save complete drafts of spreadsheets automatically
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