Data Entry Software

We work for quality of the data, for that we have developed some special macros in house which help us to make work easy with great quality. We can deliver you your customize macro as per your requirements.

Write us your customize Macro requirements.

 

DEI Excel Menu:

Above macro creates a new excel menu with below mentioned options.

Extract Hyperlink:

This option is used to extract Hyperlinks from any HTML Text pasted in Excel. As you click this option you will got a Notification Box Asking you to put all your HTML data in column A with no blank lines in between. Note : To use option you must put all the HTML Text in Column A. There must be not any blank lines in Column A between two HTML text.

Delete Blank Rows:

As you select this option it will delete blank rows from the active sheet.

Insert Line Break:

As you choose this command, it will ask you for the line break criteria, it means from where you want Line Break. For Example Space( ), Comma (,), Dot(.), Colon (:). And according to given criteria it will insert line break in Cell.

Character Map:

As you choose this command, it will invoke 'Character Map' Application. It is useful when you are typing text, and you need to enter a symbol or any special text in the cell.

Multiple Sort:

This command is override the Sort Facility of Excel. In Excel we can only multi-sort 3 columns only. While with this command you can sort as many columns as you want.

Change Case (Upper/Lower/Title):

This command is used to change case of selected cells. Select the range of cells which you want to convert in Upper Case, Lower Case or Title Case. Click the Menu Item, That's it!

Merge Multiple Cells Data:

This command is used to merge data of two different columns. If there is First name in column A, and Last Name in column B. This command will merge First Name <space> Last Name in Column A.

Transpose Multiple Rows:

This command is work same as Excel default command (Edit > Paste Special > Transpose). In Excel we can transpose single record only. Using this command we can transpose multiple Records.

Transpose in next sheet:

This command will work same as 'Transpose Multiple rows. The only difference is it will transpose data in Second Sheet.

Combine Excel Files:

This command will combine all sheets in one sheet called master sheet.

Combine Excel Sheets:

This command will combine all excel file in one single excel file, all files will be separated in different sheets in the file.

Above mentioned all in one macro is as less as US $20 only. Contact us now

 

Internet Macros:

We support Internet Macros (iMacros) www.iopus.com, and can write customized internet macros as per your web extraction requirements.