Excel Inventory Management

Closed Posted 6 months ago Paid on delivery
Closed Paid on delivery

So, on the 15th November 2023 (yesterday), I counted the stock quantity, sizes and colours that we already have at only 1 site. So, I want something on Excel that we can keep this information already.

Then

I want a tracker that will see the stock that we have coming in and out each day (however, the stock coming in will usually be the same as stock coming out as we will only order the stock if someone needs it, so 1 stock in should be 1 stock out the next day, if that makes sense?)

I want the stock in to be with the quantity, size, colour, sku code, and the date too.

Then the balance stock will see the difference between the stock in and out on each day.

That 'minimum number of stock to be kept' column should be equal to 2 instead of 1, as we always want at least 2 of each item just incase for any emergencies.

Then, the admin suggestion column next to that one, should be where the cell should be named 'Admin suggestion' if the balance stock falls below 2 (the minimum number of stock). That cell should also be highlighted in yellow.

Please see attached file as an example. PLEASE ONLY LOOK AT THE THIRD TAB IN EXCEL AS A GUIDE, IGNORE THE FIRST 2

Excel Visual Basic PHP Data Processing Excel VBA

Project ID: #37439433

About the project

87 proposals Remote project Active 5 mos ago

87 freelancers are bidding on average £32 for this job

MQamar123

Hello! My name is Muhammad and I am a tech enthusiast with over 7 years of experience in software development. I have expertise in various domains such as web development and app development. I understand from your de More

£10 GBP in 7 days
(10 Reviews)
4.6
zaahidali61

Hi, My name is Zahid. I am available to work on your project right now. I hold a master degree in business administration (finance) and I'm a full-time freelancer specializing in Data Entry, Data Processing, Excel, Web More

£35 GBP in 2 days
(26 Reviews)
4.7
Maherun75

"Hello, I work as a full-time presentation designer. From your Raw Data, I can create Word documents, PowerPoint presentations, and Excel spreadsheets. Simply show me your information and tell me what you hope to gain More

£35 GBP in 1 day
(24 Reviews)
4.5
solvitadzenite

⭐⭐⭐Excel Inventory Management ⭐⭐⭐ Hi Edi S.!!! I have reviewed the requirements for the role and believe that my skills and experience make me a strong candidate for this opportunity. I have a proven track record in so More

£40 GBP in 4 days
(3 Reviews)
2.9
baselnasser9

⭐⭐ Hello!⭐⭐ I'll create a comprehensive Excel system for your stock management. Tracking stock quantities, sizes, and colors, the system will record stock in and out with details like quantity, size, color, SKU code, More

£50 GBP in 1 day
(1 Review)
2.8
Excellis

Hello, I hope this message finds you well. I am writing to express my keen interest in your project posted on Freelancer.com. I have done similar kind of project in the past.I would like to chat with you so that we ca More

£35 GBP in 7 days
(4 Reviews)
3.6
hashirshahzad098

Hello there! My name is Muhammad Hashir and I am a highly skilled and versatile freelancer with a passion for delivering top-notch results in a variety of domains. You have given me the exciting task of designing an Ex More

£20 GBP in 1 day
(1 Review)
0.8
hnqudjit

✅ Hello Edi S.!✅ Good afternoon May I ask how you are? I want to convey my passion for your Excel Inventory Management project and my ability to manage it. I fully believe in our ability to run your project smoothly More

£40 GBP in 3 days
(0 Reviews)
0.0
zelayakeledjian1

❤️Warm greetings❤️ I've just checked "Excel Inventory Management". WHY CHOOSE ME: ✔️Experience: 250+ successful projects and 500+ overall ✔️Best Support: provides support after project delivery. ✔️On-time delivery ✔️A More

£40 GBP in 5 days
(0 Reviews)
0.0
exyosvhq

✅ Hi, Edi S.!✅ I have read the job description carefully. As a senior web developer, I am confident in Data Processing, PHP, Excel VBA, Excel and Visual Basic. I can work with you right now. Looking forward to discussi More

£40 GBP in 4 days
(0 Reviews)
0.0
vnhegmtb

❤️Hi Edi S.❤️ This is Expert five years of experience in this fields. I am familiar with Visual Basic, PHP, Excel, Data Processing and Excel VBA. Maria

£40 GBP in 4 days
(0 Reviews)
0.0
kianaenickhejnj1

❤️Hi, Edi S. As a senior full stack developer, I have strong experience in creating 500+ professional clean projects for the past 5 years So I can handle your project that is "Excel Inventory Management". I am very fam More

£40 GBP in 4 days
(0 Reviews)
0.0
gcnfcnaf

??? Hello, Sir ??? Your project is very similar to my last project and if you want, I will show the result. I am very familiar with Excel, Excel VBA, Visual Basic, Data Processing and PHP and I can start immediately. More

£10 GBP in 5 days
(0 Reviews)
0.0
dyffdnrl

❤️ Hello there Edi S., Good afternoon! ❤️ I’ve carefully checked your requirements and really interested in this job. I’m full stack node.js developer working at large-scale apps as a lead developer with U.S. and Euro More

£10 GBP in 3 days
(0 Reviews)
0.0
Sophia0109

Hi Edi S., Good afternoon! I’ve carefully checked your requirements and really interested in this job. I’m full stack node.js developer working at large-scale apps as a lead developer with U.S. and European teams. I’ More

£10 GBP in 5 days
(0 Reviews)
0.0
codernice2

Hi Edi S., I am supportive and enthusiastic Full Stack Developer with professional experience in dynamic and deadline- driven work environments. Over the past 9 years, I am professional Web developer with skills inc More

£40 GBP in 2 days
(0 Reviews)
0.0
CorpusChristi00

Dear client. Glad to bid on your project because my skills match your project very well. I am familiar with Excel, Visual Basic, PHP, Excel VBA and Data Processing. As a senior Software Developer and Designer with over More

£40 GBP in 4 days
(1 Review)
0.0
chrisgordon313

Dear Edi S.. This is Chris. How are you? As a US top rated developer, I have a professional knowledge and experience of working in AI, MERN, CMS and Mobile App. Excel, Visual Basic, Data Processing, Excel VBA and PHP a More

£40 GBP in 3 days
(0 Reviews)
0.0
coderplayer0110

Dear Edi S.. How are you? Excel VBA, PHP, Visual Basic, Excel and Data Processing are my best skills. As a 14 years full stack Web/AI/Mobile app developer, I can start the work immediately and will finish the task with More

£40 GBP in 4 days
(0 Reviews)
0.0
AlishaWhite212

Hi, Edi S. How are you? I am Alisha located in FL, US. Excel, Excel VBA, PHP, Data Processing and Visual Basic are my best skills. I am very interested in your project and ready to discuss. As a 12 years web developer, More

£40 GBP in 25 days
(0 Reviews)
0.0