Find Jobs
Hire Freelancers

Excel Business Simple Project

$30-250 USD

Zamknięte
Opublikowano ponad 3 lata temu

$30-250 USD

Płatne przy odbiorze
Please read the following requirements to be able to do the project... * The file has two sheets: Inventory and Invoice. Inventory is the stock of the products, and Invoice is the bill for customers when someone purchases something, I will fill it out. * The idea of this project, whenever I use the scanner to scan the barcode (Only numbers) that was saved in Inventory sheet; The scanned barcode should give from Inventory to the Invoice sheet as follow:
the Barcode scanned number, Product ID, Product Name, Product Picture as well (I will put pictures), Wholesale Price Per Piece, and Selling Price. You need to link Inventory and Invoice sheets. 
 * Quantity in Inventory should be automatically subtracted and updated whenever I put Quantity in Invoice sheet. 
 * In Inventory sheet whenever I scan a product that is already existed it should be updated and not to add it again or duplicated. * Please make sure the file is working on Google Sheets as well. So, the idea is just like supermarket, and here I will give an example to clarify the idea more. For example, if I have a product that its Barcode number is already registered in Inventory, and someone purchased this product. So, I need to open the invoice sheet, and scan the barcode, this barcode should give me from Inventory sheet; Barcode scanned number, Product ID, Product Name, Product Picture, Wholesale Price Per Piece, and Selling Price. And Quantity in Inventory should be automatically updated and subtracted from Quantity I put in Invoice.
Identyfikator projektu: 26834829

Informację o projekcie

17 ofert
Zdalny projekt
Aktywny 4 lata temu

Szukasz sposobu na zarobienie pieniędzy?

Korzyści ze składania ofert na Freelancer.com

Ustal budżet i ramy czasowe
Otrzymuj wynagrodzenie za swoją pracę
Przedstaw swoją propozycję
Rejestracja i składanie ofert jest bezpłatne
17 freelancerzy składają oferty o średniej wysokości $139 USD dla tej pracy
Awatar Użytkownika
Hi, Greetings! ✅checked your project details: Excel Business Simple Project ✅Completed Time: In project deadline We have worked on 600 + Projects. I have 6 + years of the experience in same kind of projects. If you are looking for a true Freelancer, I am the Right person for you. I am available almost 24-7 and am very responsive. I feel proud that I am a trusted Freelancer who pleases almost every single client. You can rest assure, your work will be delivered well in advance of others, with passion and accuracy. I guarantee you instant communication & responses when you need me. Why choose me? I think every client is the reason for my success. I only take projects which I am sure I can do quickly. My Portfolio Items: https://www.freelancer.com/u/schoudhary1553 I would really like to work with you on this project. If interested, Kindly contact me via chat for further details and discussion.. Thank you Sandeep Digital screencast
$250 USD w 5 dni
4,9 (364 opinii)
8,1
8,1
Awatar Użytkownika
Hi, I have the expertise necessary to deliver this Project in Google sheets and the relevant experience of successfully delivering similar Projects. As meticulously detailed out in your job post, in the the delivered google sheet, based on the scanned Bar code list captured, the Invoice sheet will get auto-populated with the corresponding Product IDs , Product Names, Wholesale Price per piece and Selling Price per piece, from the information available in the Inventory sheet. Quantity will be entered manually which will auto-complete the Invoice with the item-wise totals and the Invoice grand total. Please revert to discuss and finalize at the earliest. Look forward to work with you soon. Thanks, DC
$223 USD w 5 dni
5,0 (14 opinii)
5,4
5,4
Awatar Użytkownika
Expert in excel with over 15+ years of experience and over 4.9 user rating on this platform. Completed over 54 projects on FL. Expertise - Macros Formulae VBA User forms Willing to share a sample of my work done on personal finance applications. Looking forward to hearing from you. Thank you BAVarun PS: Do check my ratings for excel projects on this platform.
$40 USD w 7 dni
4,9 (37 opinii)
4,7
4,7
Awatar Użytkownika
Here! I have understand your requirement, I have previously created some excel sheets, for similar work, I can easily built your Inventory management file as per your requirement, I will provide yoou all the necessary revision. I have a strong grip on MS Excel (VBA, Advance Filter, MACROS, Pivot Table, Vlookup, Hlookup, Data Validation, Conditional Formatting, Financial Templates, Userform). You can check my reviews for excel project on my wall. I'm detail-oriented, reliable, and efficient. I like working in Word and Excel, and English is my native language. I will produce high-quality results and would be interested in other work from you if you're satisfied with me! You can check my skills by giving me a sample assignment. or I can send you my sample work if you please text me.
$60 USD w 3 dni
5,0 (3 opinii)
3,2
3,2
Awatar Użytkownika
Hi, I'm a professional and expert in Data works or projects..My skills and services include: - Web scraping - Data entry - Data mining - Data processing - Excel - MySQL - Oracle -Financial Analysis -Advanced Excel -MS Office -Python -PowerPointMacros -Automatioin -Automation tools -VBA -Excel and VBA automation - etc. A professional having more than 7 years of experience in financial modeling, VBA macros, MS Office automation with postgraduate degree, Worked in reputed organisations on senior level. I am expert in my field, who knows the value of time, very hard working and always delivers the work on time. I always deliver the work well in advance with continues communication & timely response until satisfactory completion of the project. I only accept the projects which I am sure can be done within the stipulated time frame and budget.. I always deliver 100% Satisfaction to the client. Hope my skill and work can help you with your business. i look forward to have further discussion with you in the chat. Thanks Regards ATEMENU.D
$30 USD w 1 dzień
4,8 (7 opinii)
3,5
3,5
Awatar Użytkownika
With reference to your requirement, I wish to apply for this role. As an analytical and dynamic individual who has a proven history of exceeding expectations through performance, I believe I would be able to participate and impact considerably the ongoing operational success of your business. My present employment as a Senior Accountant has helped me to develop my abilities in key areas such as:  Accounts preparation and finalization  Book keeping on different softwares. (Quickbooks, Xero, ERP, SAGE)  VAT returns and summaries with detailed reconciliations  MIS reporting  Accounts payable and receivable  Profit and loss analysis  Management accounts  Financial Modelling  Cash flow forecasting  Sensitivity analysis  Budgeting control  ERP management of AP, Asset and General modules I can combine my effective communication skills with functional knowledge to identify opportunities and deliver a satisfactory outcome while working alone or as a part of a larger team. You will find me as someone who can juggle both financial and bookkeeping responsibilities along with general administration and customer service tasks. I have enclosed my resume for your review and would be thankful for an opportunity to meet with you in the near future to further discuss my application. Sincerely, M. Jawad Mazhar
$140 USD w 7 dni
5,0 (1 opinia)
2,8
2,8
Awatar Użytkownika
⭐⭐Hello⭐⭐ Are you going to find an expert to finish your work? You are in the right place. I have strong VBA skills and it's the best solution to satisfy your requirement. I have ever made VBA DB management, Dashboard creating, Integrate APIs to get data from website or scrapping website, and save data in spreadsheets, building charts... VBA is more strong than Macro, It also uses all functionality of VisualBasic, So I can do it perfectly with VBA. I have finished many automation Excel works using VBA, My English is very conversational and I can fully ensure your requirement. Please contact me and let me work for you now. Thanks for reading. Regards.
$250 USD w 5 dni
5,0 (1 opinia)
2,2
2,2
Awatar Użytkownika
**Please give me a chance** I can start work on ** Excel Expert ** Right Now and I am pretty confident that I will be able to get your work done. I am 5 Star rating Freelancer also I have more then 3 year experience in This Field. Here is my profile portfolio https://www.freelancer.com/u/contactpuneet33 I am really interested to know more about your project. Please Give me more details about your project over chat. thanks
$30 USD w 1 dzień
5,0 (2 opinii)
1,0
1,0
Awatar Użytkownika
Hi I have 13years experience in excel VBA. also I worked in barcode implementation for 6years for similar projects. I believe you should use USB port scanner. even scanner I'd, and other details must come from scanner input only. ok... Anyway we will discuss in detail. so that we can make it clear and work on it
$194 USD w 3 dni
5,0 (2 opinii)
0,6
0,6
Awatar Użytkownika
i does your work data entry ,excel,complet your work your time you hire me , i do this your work co
$140 USD w 7 dni
0,0 (0 opinii)
0,0
0,0
Awatar Użytkownika
Good afternoon! Hope you are doing well and staying safe! I am a Data analyst I can give you a garantee of free project if it doesnt exceed you requirements, I am looking to get reputation. Expert on excel and google sheets, this project sounds very simple. Time can change depending of the amount of information on the project. Stay safe!
$200 USD w 5 dni
0,0 (0 opinii)
0,0
0,0
Awatar Użytkownika
I will complete this work in 3 days Relevant Skills and Experience You will satisfied with my work
$156 USD w 3 dni
0,0 (0 opinii)
0,0
0,0
Awatar Użytkownika
Hello I am an engineer with experience in worksheet automation. I have worked on inventory management systems and Enterprise Resource Planning. I fully understand your requirements and will provide you best and simple automated sheet with easy to understand user interface. Please consider me for this project. Thanks!
$150 USD w 4 dni
0,0 (0 opinii)
0,0
0,0
Awatar Użytkownika
Hi, I am highly experienced with automating MS Excel to filter and match data. This project seems to be within my area or expertise. I have lots of experience in automating excel files to assist accounts. Please send me more details and I could develop a project proposal.
$167 USD w 4 dni
0,0 (0 opinii)
0,0
0,0
Awatar Użytkownika
Dear employer, Please note that I am an expert in excel and I have certificates proving so. VBA also is not a problem for the work you described. Thank you.
$200 USD w 3 dni
0,0 (0 opinii)
0,0
0,0
Awatar Użytkownika
I can work on vba to process all kinds of excel data manipulations. Please provide detailed description of your requirements.
$30 USD w 1 dzień
0,0 (0 opinii)
0,0
0,0

O kliencie

Flaga SAUDI ARABIA
Jeddah, Saudi Arabia
5,0
2
Zweryfikowana metoda płatności
Członek od mar 6, 2020

Weryfikacja Klienta

Dziękujemy! Przesłaliśmy Ci e-mailem link do odebrania darmowego bonusu.
Coś poszło nie tak podczas wysyłania wiadomości e-mail. Proszę spróbować ponownie.
Zarejestrowani Użytkownicy Całkowita Liczba Opublikowanych Projektów
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Wczytywanie podglądu
Udzielono pozwolenia na Geolokalizację.
Twoja sesja logowania wygasła i zostałeś wylogowany. Proszę, zalogować się ponownie.