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
1

On BitsDuJour Today

Sticky Password Premium (Mac & PC) Discount
Mac & PC
Sticky Password Premium
Never forget a password again.
100

Excel Add-ins Deals

AbleBits: Merge Tables Wizard for Microsoft Excel (PC) Discount
for PC
AbleBits: Merge Tables Wizard for Microsoft Excel
Merge Two Excel Spreadsheets in Seconds
Spreadspeed (PC) Discount
for PC
Spreadspeed
Reduce Spreadsheet Errors, Get More Done
Dose for Excel Add-In (PC) Discount
for PC
Dose for Excel Add-In
Become More Productive in Microsoft Excel
40
Change Absolute References to Relative References in Excel (PC) Discount
for PC
Change Absolute References to Relative References in Excel
Reformat Excel References in a Flash
FlexView (PC) Discount
for PC
FlexView
Import Database Information into Microsoft Excel
25
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%
Follow Us
© Copyright 2024 BitsDuJour LLC. Code & Design. All Rights Reserved. Privacy Policy