Closed

Excel Business Simple Project

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.

Skills: Excel, Excel VBA, Excel Macros, Google Sheets, Excel VB Capabilities

See more: small business spreadsheet for income and expenses, excel spreadsheet for business expenses, excel templates for business plan, excel templates for business expenses, best excel templates, microsoft excel templates, excel templates for business accounting, excel spreadsheet templates for tracking, simple project schedule excel, simple project tracking excel workbook, create simple project excel, simple excel visual basic project, make simple project excel, simple project management marketing excel template, excel simple project need, pdf excel simple project, simple project google maps, project excel business cards, please somebody help me i m trying to write a very good song for a project and i need help in making the following rhyming words, e village project and its software developer in india

About the Employer:
( 2 reviews ) Jeddah, Saudi Arabia

Project ID: #26834829

17 freelancers are bidding on average $139 for this job

schoudhary1553

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 More

$250 USD in 5 days
(364 Reviews)
8.1
dfexcel

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 g More

$223 USD in 5 days
(14 Reviews)
5.4
BAVarun

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 o More

$40 USD in 7 days
(37 Reviews)
4.7
raoarslan56

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 More

$60 USD in 3 days
(3 Reviews)
3.2
hayteekeys

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 More

$30 USD in 1 day
(7 Reviews)
3.5
MJMtheaccountant

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 participat More

$140 USD in 7 days
(1 Review)
2.8
fadeevdoma

⭐⭐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, Dashboa More

$250 USD in 5 days
(1 Review)
2.2
contactpuneet33

**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 i More

$30 USD in 1 day
(2 Reviews)
1.0
rameshraja86

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 scanne More

$194 USD in 3 days
(2 Reviews)
0.6
yogendramehar

I will complete this work in 3 days Relevant Skills and Experience You will satisfied with my work

$156 USD in 3 days
(0 Reviews)
0.0
Shahrukhmansuri4

i does your work data entry ,excel,complet your work your time you hire me , i do this your work co

$140 USD in 7 days
(0 Reviews)
0.0
turm09

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 More

$150 USD in 4 days
(0 Reviews)
0.0
alfredosagaceta

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 More

$200 USD in 5 days
(0 Reviews)
0.0
$111 USD in 2 days
(0 Reviews)
0.0
YGME

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 m More

$167 USD in 4 days
(0 Reviews)
0.0
aisharshir

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 in 3 days
(0 Reviews)
0.0
aishwaryaraut21

I can work on vba to process all kinds of excel data manipulations. Please provide detailed description of your requirements.

$30 USD in 1 day
(0 Reviews)
0.0