Đã hoàn thành

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

Kĩ năng: Excel, Excel Macros, Excel VBA, Programming, Visual Basic

Xem nhiều hơn: 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

Về Bên Thuê:
( 387 nhận xét ) Victoria, Canada

ID dự án: #20038266

Được trao cho:

aubrey03

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 Thêm

$200 USD trong 2 ngày
(114 Đánh Giá)
5.8

22 freelancer đang chào giá trung bình $208 cho công việc này

schoudhary1553

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 Thêm

$200 USD trong 4 ngày
(327 Nhận xét)
7.9
Nidhijain123

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 Thêm

$250 USD trong 10 ngày
(101 Nhận xét)
6.2
citijayamala

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 Thêm

$250 USD trong 5 ngày
(63 Nhận xét)
5.6
Taisho

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 Thêm

$180 USD trong 3 ngày
(61 Nhận xét)
5.2
vsprybhanu

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, Thêm

$250 USD trong 3 ngày
(72 Nhận xét)
5.5
bhupendrayadav

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 Thêm

$150 USD trong 3 ngày
(26 Nhận xét)
4.5
jinc107

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 Thêm

$200 USD trong 7 ngày
(1 Nhận xét)
4.4
fattahaabdul

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 trong 7 ngày
(3 Nhận xét)
3.4
Aishwaryakumari

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% Thêm

$150 USD trong 1 ngày
(16 Nhận xét)
3.1
sergeyprince

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 Thêm

$150 USD trong 10 ngày
(9 Nhận xét)
2.4
TopWritingGuru

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 Thêm

$150 USD trong 1 ngày
(1 Nhận xét)
1.2
PremiumSolution

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] Thêm

$150 USD trong 1 ngày
(1 Nhận xét)
0.6
$222 USD trong 10 ngày
(0 Nhận xét)
0.0
$222 USD trong 10 ngày
(0 Nhận xét)
0.0
$222 USD trong 10 ngày
(0 Nhận xét)
0.0
Dolanplease1

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 Thêm

$150 USD trong 1 ngày
(0 Nhận xét)
0.0
subhajeet123456

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 Thêm

$166 USD trong 10 ngày
(0 Nhận xét)
0.0
leeshuntie87

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 Thêm

$200 USD trong 3 ngày
(0 Nhận xét)
0.0
PageOllice

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 Thêm

$220 USD trong 3 ngày
(0 Nhận xét)
0.0
$222 USD trong 10 ngày
(0 Nhận xét)
0.0