Create Excel based application

I need to have the excel based application for following need:-

The purpose of the application is to scan and track barcoded inventory. The application will run on 3 computers, (all connected to same internet connection), so the data should be updated real time between the 3 computers.

What I need the application to do:-

Each of our products have 2 barcodes on them. We always need to scan both barcodes.

The purpose of the application is to track the inventory movement between 1 computer and next.

So the first time, the barcode (2 barcodes) is scanned in 1computer excel sheet, then add the inventory to inventory IN column along with date stamp for it

For 2nd Time the barcode (2 barcodes) is scanned in same computer, that inventory is moved to inventory OUT column with date stamp

The main excel file (to be shared between 3 computers) can be updated from any of the computer location. The Computer 1 will have 6 Columns, Inventory In which will have 2 columns for 2 barcodes, and 1 more column for Time Stamp (the date and time the inventory is scanned in), plus Inventory Out which will another 2 columns for 2 barcodes, Time Stamp for inventory out

So overall excel file will have 18 columns (6 columns per computer as stated above x 3 computers).

I also need a macro function, which when I run it, will search for the 2 barcodes in inventory in, and the same 2 barcodes in inventory out column, and if matched, it will remove the complete barcode entries in those columns and add it in a new sheet called Finished Sheet

This is very simple Excel based application which if possible we want you to create. I need it very urgently

Kemahiran: Excel, Excel Macros, Excel VBA, Pengaturcaraan , Visual Basic

Lihat lagi: turn excel web based application, create windows mobile application web based aspnet2, script create excel 2007 macro, create calculator based excel file web, converting excel web based application, word macro create excel sheet, macro create excel report append columns, create excel word macro, create excel macro check active directory account status, word macro excel based styles, create excel web application macros, word macro create excel file, macro copy rows excel based cell content, cell address based vlookup result macro excel, vba macro create excel toolbar free, create web based sip application, create account code excel based tables, powershell create excel macro, create web based application using visual studio 2012, create excel based iphone app

Tentang Majikan:
( 387 ulasan ) Victoria, Canada

ID Projek: #20038266

Dianugerahkan kepada:


I am an MS Excel and Access Specialist and an experienced Freelancer who is dedicated to provide quality results within a reasonable timeline and budget. Accuracy is my priority so I believe I am the best freelancer fo Lagi

$200 USD dalam 2 hari
(114 Ulasan)

22 pekerja bebas membida secara purata $208 untuk pekerjaan ini


Hello, I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. Pl Lagi

$200 USD dalam 4 hari
(327 Ulasan)

Hello, I have read and understood what has to be done in this task. I have sound experience in performing such kind of work as I have done lot of project of similar kind in the past. I think I can assist you in ge Lagi

$250 USD dalam 10 hari
(101 Ulasan)

1. I am an expert in Excel, and can develop your excel application as per the given requirement, Excel formulas, and all excel functions, macros, lookup, pivot tables and charts. I read your project description and I Lagi

$250 USD dalam 5 hari
(63 Ulasan)

Hello, I can write VBA macros to manage these barcodes. About data being updated in real time, is it required to automatically keep data updated all the time or would it be enough to do so when the user requests an up Lagi

$180 USD dalam 3 hari
(61 Ulasan)

Hi, My name is Virendra. An Experienced Data Analyst and Macro Developer. I have read your instructions carefully. I have excellent knowledge and experience of Manipulating and Exchanging Data in Multiple Sheets, Lagi

$250 USD dalam 3 hari
(72 Ulasan)

I am postgraduate (MBA) with more than 5 years of experience in advanced excel based tools and applications, VBA automation, MS Office automation and data processing. I have successfully completed similar projects, ple Lagi

$150 USD dalam 3 hari
(26 Ulasan)

Hi. Thanks for your request. I read your description and understood the job. I am interested to work for you. I have an experience of 4 years in Excel, VBA etc. Please contact me so we can discuss more about your job Lagi

$200 USD dalam 7 hari
(1 Ulasan)

I will make excel based application for you. I have 8+ years of experience . I assure you that i will give 100% quality work. Let us discuss and proceed further in chat. I am online. Please reply.

$500 USD dalam 7 hari
(3 Ulasan)

Dear Client, I can Create an Application in Excel as per your requirements. I have excellent experience of Data entry, Web Scrapping,MS Office and Web Research for more than 4 Year’s. Never ends up until you are 100% Lagi

$150 USD dalam sehari
(16 Ulasan)

Hello. I have got 8 years of rich experiences in VBA. I can do VBA programming as fast as you want .I am Data Processing , Excel VBA Expert who knows the value of time, very hard working and always delivers the work o Lagi

$150 USD dalam 10 hari
(9 Ulasan)

Hi! Since functioning from 2008, I have accomplished hawk eye for the requirements, and I have all the aptitudes to produce showpiece as per your anticipations. Creating a masterpiece is an art, and I am a master in it Lagi

$150 USD dalam sehari
(1 Ulasan)

Hi I assure you quality work as per the mentioned deadline. I can provide you with a guarantee of 0% plagiarism and can provide your work as per requirements along with free of cost changes facility. [login to view URL] Lagi

$150 USD dalam sehari
(1 Ulasan)
$222 USD dalam 10 hari
(0 Ulasan)
$222 USD dalam 10 hari
(0 Ulasan)
$222 USD dalam 10 hari
(0 Ulasan)

I am a very goal oriented and dedicated person who will do my best to finish all the desired goals as well as put all my effort into completing the goals. I am always determined to deliver projects to my clients before Lagi

$150 USD dalam sehari
(0 Ulasan)

I have gone through your job requirement and I understand that it requires a high speed typing skills with 100% accuracy. I have 4+ years experience working with Ms Excel and Ms office tools. Relevant Skills and Expe Lagi

$166 USD dalam 10 hari
(0 Ulasan)

Hello, Sir. I have checked your proposals carefully. I have rich experiences more than 7 years in VB.Net/C# programming, in particular MS office macro. My expertise and experience will complete your project perfectly i Lagi

$200 USD dalam 3 hari
(0 Ulasan)

Hello Dear, I am expert in excel. I can work immediate basis. I am interested in your project and invite you to discuss in details. Please reply so that I can show you my past result. Looking forward to hear from yo Lagi

$220 USD dalam 3 hari
(0 Ulasan)
$222 USD dalam 10 hari
(0 Ulasan)