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
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 for this task.
I have a lot of experience in creating complex automation tools, formulas, databases, queries and macros.
You may check some of my projects here: [login to view URL]
$200 USD in 2 days
4.8 (129 reviews)
6.0
6.0
20 freelancers are bidding on average $211 USD for this job
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.
Please visit : https://www.freelancer.com/u/schoudhary1553
I have excellent command over English. I am a hard worker, productive and worthy of your attention I hope, I would be the right candidate for this post. Awaiting an affirmative response from you.
Kinds Regards,
Sandeep
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 getting this task done with more focus on quality and getting it delivered on time.
Regards,
Nidhi
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 am sure that I can handle your project.
2. Have done many projects in Excel, created many dashboards, and Business intelligence tool for forex markets. Experienced MBA Finance as well.
3. Your project will be delivered on time with high standard
4. Assistance will be provided with number of clarifications until client satisfaction
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 update, for example, clicks on an icon? This way there would be no slowdowns and shared workbooks should be avoided for their inconsistency and bugs.
As I understood there would be just this one file with 18 columns, 2x barcode in with 1x timestamp, 2x barcode out with 1x timestamp. So 6 columns x 3 users.
Automatic detection of the same barcode scanned that moves inventory into out columns is self-explanatory. I only wonder whether the other feature to match barcodes and move them to the Finished sheet should allow the user to enter barcodes or find all possible matches and move them to Finished itself.
I can start this project immediately and finish it on short notice. I write macros only for Windows.
Best Regards
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, Using Advanced Formulas, Critical Programming, Developing System for Management and Creating Reports.
I have done mostly Excel VBA Programming jobs.
Please check my portfolio to see my work –
https://www.freelancer.com/u/vsprybhanu.html?page=portfolio
So, I can do this job nicely.
Ready to start, please message me to discuss your project in more details.
Thanks,
Virendra
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, please have a look at my portfolio for details.
I have developed excel based tools and models for Ernst and Young also.
You can get your work done here with highest quality at lowest price.
Looking forward to work with you
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.
If you hire me, I'll start working now.
I am waiting for your response. Thanks!
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% satisfied with each and everything. I have worked on the similar projects before, so with my interpersonal skills and experience I would be happy to work for you.
Best Wishes,
Aishwarya Kumari
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.
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.
For further discussions, please message me in private messenger so we may finalize the deal.
Looking Forward; Top Writing Guru
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. https://www.freelancer.com/u/PremiumSolution?w=f. Thanks!
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 meeting the dead line with 100% satisfaction & loyalty has its own unique project description.
I worked as a Data entry Specialist for almost 6 years. My work helped me broaden my knowledge in computer software, improves my typing skill (75WPM), being more accurate in data entry and help me enhance my ability to work independently.
Client's satisfaction is my top priority. I want to be the best provider for my clients. Giving 100% fulfillment.
Thank you and God blessed!
Strengths:
-Communication (written and oral)
-Flexibility (adaptability, willing to change)
-Integrity (honest, ethical)
-Teamwork (cooperative, supportive)
-Interpersonal Skills (patience,empathy)
-Responsibility (reliable, self-disciplined)
-Positive attitude (optimism, confident)
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 you.
Thanks,
Page O.
Hello sir i am an engineer as well as a programmer and have extensive work experience in my fields. I have already designed a pretty bigger inventory management software than this. So I can also do this and easily complete it. If you want i can show you my previous work
!!!I can complete this within 1 day and in cost of only $120!!!
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 Experience
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.
