Complete My Inventory Spreadsheet

₹1500-12500 INR

In Progress

Posted 19 minutes ago

₹1500-12500 INR

Paid on delivery

I already have the framework of an inventory workbook, but many rows are still blank and the reporting tab is not yet pulling the right figures. I’ll send you two files: • the partial master list of items and • the report sheet that should summarise everything. What I still need filled in is the inventory level data—specifically the Quantity in stock for every SKU. While you’re doing that, each item must also be correctly tagged under the following columns so the report works: • Product type • Location • Supplier • Expiry • PACKING • UNITS Feel free to add or tweak formulas, look-ups, data validation, or conditional formatting if it helps the sheet update itself automatically; just keep the layout intact so my team recognises it. Once done, the report tab should instantly reflect current stock quantities without any manual edits. Deliverable: the updated Excel workbook, completely populated and recalculating correctly, ready for me to drop straight into use.

Project ID: 40664338

About the project

7 proposals

Remote project

Active 1 min ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

Awarded to:

@belarjsoufiane20

Hi, I can complete your inventory workbook while keeping the existing layout intact. I’ll populate the Quantity in Stock for each SKU and correctly assign Product Type, Location, Supplier, Expiry, PACKING, and UNITS so the reporting tab pulls the right figures automatically. I can also fix or improve the formulas, lookups, and validation where needed so the report updates correctly without manual edits. You’ll receive a fully populated, recalculating Excel workbook ready to use. Best regards, Soufiane

₹6,000 INR in 1 day

4.9

(42 reviews)

5.7

7 freelancers are bidding on average ₹4,943 INR for this job

@gowrik16

Hi, I can help you complete and automate your inventory workbook while keeping the existing layout intact. I have hands-on experience with Excel, Power Query, data cleaning, lookups, formulas, data validation, conditional formatting, and automated reporting. I can populate the Quantity in Stock for each SKU, correctly categorize Product Type, Location, Supplier, Expiry, PACKING, and UNITS, and fix the report formulas so the summary updates automatically. My approach will be: * Review both the master list and report sheet * Populate and validate the missing inventory information * Correct or create the required formulas/lookups * Ensure the report reflects the latest stock quantities automatically * Test the workbook thoroughly before delivery I have completed similar Excel/data-analysis and reporting projects and can start immediately. I will preserve your existing layout so your team can use the workbook without changing their workflow. I’d be happy to review the two files and get started. Thank you. K. Gowri

₹5,000 INR in 3 days

5.0

(1 review)

1.1

@victoriab187

Hi, I can complete and optimize your inventory workbook while keeping the existing layout intact. I’ll populate Quantity in Stock for every SKU and accurately tag Product Type, Location, Supplier, Expiry, PACKING, and UNITS. I’ll also repair or improve formulas, lookups, validation, and conditional formatting so the reporting tab updates automatically and reliably. I’ll thoroughly test the workbook for calculation accuracy, consistency, and usability before delivery. You’ll receive a fully populated, recalculating Excel file ready for immediate use by your team. Victoria

₹7,000 INR in 7 days

0.0

(0 reviews)

0.0

@shikhajatav396

I have 5+ years - Excel, inventory management, VBA/macros, data entry, formulas, lookups, and automated reporting. I can and want to complete your inventory workbook, populate SKU quantities and required tags, and ensure the report updates automatically. Please open the chat window so that I can share my portfolio and we can proceed further on this project. In addition to your project needs, I'll provide you with clean source code, free bug patches, and maintenance. I am awaiting your positive response. Regards Shikha

₹1,500 INR in 7 days

0.0

(0 reviews)

0.0

@Abdullahkk10

Hi, I can complete your inventory Excel workbook accurately, including stock quantities, product categorization, formulas, and the reporting sheet. I’m experienced with Excel, data entry, formulas, lookups, and inventory management. I’ll keep your existing layout intact and ensure the report updates correctly without manual edits. I’m ready to start immediately. Looking forward to working with you!

₹2,500 INR in 1 day

5.0

(1 review)

0.0

@bhargav922002

With over a decade of experience as a web and app developer, my technical skills and proficiency in Visual Basic make me the ideal candidate to complete your inventory spreadsheet. I understand the importance of accurate data and seamless reporting for smooth business operations. In my previous projects, I have been responsible for creating similar automated systems with real-time data updates that translate into meaningful outputs, saving valuable time and effort. Moreover, the nature of my work has required me to develop a keen eye for detail to ensure that user needs are met without compromising functionality. I guarantee that your current layout will remain intact, while effectively tagging each item under the appropriate columns per your specifications. Additionally, I will be more than happy to leverage any relevant formulas, look-ups, or other features to enhance the sheet's automation capabilities. Together, we can transform your partial master list into a fully-populated and calculating inventory workbook that not only reflects accurate stock quantities but also integrates smoothly with other parts of your business process. My track record of delivering quality products on time is indicative of my commitment to client satisfaction. It would be an honor and pleasure to collaborate with you on this project and any other digital solutions you need for your business. Let's make your vision happen!

₹7,000 INR in 7 days