Customisation of Excel for Store Management

Job Description:

I have created stock report. Now, I using dropdown list for "Opening balance", "Inward", "Outward" and "closing balance" in column and put values separately in different columns for all three options.

Now, I want calculate the closing stock at the end of each day. for this, I have to sum values in "Opening Bal." column with sum of values "Inward" column and then subtract the sum of values in "Outward" column of entire day. I have to perform same at the end of the day.

My problem is that is there way or function i put so it calculate closing stock values automatically when i put a drop-down option as "Closing Stock".

And It should only sum the values of "Opening balance", "Inward" and "Outward" before previous "Closing Stock".

Taidot: Excel, Visual Basic, PHP, Tietojenkäsittely, Tietojärjestelmäarkkitehtuuri

Tietoa asiakkaasta:
( 1 arvostelu ) vidisha, India

Projektin tunnus: #35465981

Myönnetty käyttäjälle:


ok sure i can customize your excel sheet as per your store data pls PM me can we discuss few quires wait for reply [login to view URL]

₹5000 INR 2 päivässä
(37 Arvostelua)

26 freelanceria on tarjonnut keskimäärin ₹6885 tähän työhön


Top 1% in Hi, Greetings! ✅checked your project details: ✅Completed Time: In project deadline We have worked on 850 + Projects. I have 6 + years of the experience in same kind of projects. I am a Lisää

₹12000 INR 5 päivässä
(663 arvostelua)

Hello Devraj R., We would like to grab this opportunity and will work till you get 100% satisfied with our work. We are an expert team which have many years of experience on PHP, Visual Basic, Data Processing, Excel, Lisää

₹7000 INR 7 päivässä
(95 arvostelua)

Customisation of Excel for Store Management Good afternoon Devraj R. , Hi I am a very experienced statistician, data scientist and academic writer. I have completed several PhD level thesis projects involving advanced Lisää

₹12500 INR 6 päivässä
(106 arvostelua)

Hello! I'm interested in your project. Your task is clear to me and I am ready to solve it. I have extensive and successful practical experience in processing and analyzing data in Excel, including using formulas and m Lisää

₹12500 INR 3 päivässä
(127 arvostelua)

Hello there Iam excel and data analysis EXPERT level with top rating done projects before I can done this within short time also i can provide previous samples for make you understanding better about me and my skills. Lisää

₹11500 INR 2 päivässä
(202 arvostelua)

Hey, I'm an Advanced Level Exce Expert and will do it. Please send me a message so we can discuss further. Thanking You

₹2500 INR 1 päivässä
(59 arvostelua)

Hi, I'm a Chartered Accountant from Institute of the Chartered Accountants of India ( Top recognised body in accounting and finance department ) Apart from that I have undergone 5 years of extensive training in one of Lisää

₹8000 INR 2 päivässä
(26 arvostelua)

Hello, I can do your project and I have a solution along with relevant inventory management experience of SAP B1. Please review my profile as i have below relevant skills and experience required for this project. Exc Lisää

₹2500 INR 1 päivässä
(7 arvostelua)

Hi There, As an Excel and VBA Developer, I can help you to automated your "stocks file according to your three dropdown" and i can do this easily & quickly. I have also worked this type of similar project and i have m Lisää

₹12500 INR 1 päivässä
(8 arvostelua)

Hello, I am Vikram, read the project description auto calcualte sum based on 'closing stock in drop down'. I can help write the formula's or give VBA solution that will do the work in few seconds. I am experienced and Lisää

₹2500 INR 2 päivässä
(24 arvostelua)

Hi, I have experience in writing macros. Also i use pivot table/vlookup for my routine work. I need to see at excel sheet u made. Thanks Sandeep

₹7000 INR 7 päivässä
(11 arvostelua)

"Sir, Excel and Ms word is my filed and complex formulas is my passion. I am an Excel Advanced Level Expert. This is basic work for me. I can complete this project with added quality. About me I am a Chartered Accounta Lisää

₹1500 INR 1 päivässä
(0 arvostelua)

I can do it within 4 days. I have been doing this kind of work from last 4 years. I have expertises in it.

₹10000 INR 7 päivässä
(0 arvostelua)

I have all the skills and experience listed in the job description, and I'm confident that I can make an immediate impact on your report.

₹2000 INR 7 päivässä
(0 arvostelua)

I can work for you better than everyone else. Hire me and u gonna be surprised with my result. I am currently studying and got leisure time. So i wanna earn

₹7000 INR 7 päivässä
(0 arvostelua)

Hi, GREETINGS ! Being qualified from a reputed academy in Data Science where I studied, learned and got certified with very good percentage. I'm a data analyst and good at converting raw data into into meaningful read Lisää

₹5000 INR 7 päivässä
(0 arvostelua)

Please give me an opportunity i will do all needfull in time? Hello there, I am an excel specialist. I can create interactive graphs for your data. I am skilled and experienced in advanced excel. I have experiences w Lisää

₹7000 INR 7 päivässä
(1 arvostelu)

I have work experience of more than 3 year in Industry as Data Scientist and Excel Expert to resolve the client queries with options.

₹2000 INR 3 päivässä
(0 arvostelua)

I am in CA final, great skill in MS Excel and other Data related work. Best and fast typing skill , done Audit of many listed companies, so better at time managment and skills.

₹2000 INR 1 päivässä
(0 arvostelua)

I am having lot of experience in stores accounting and stick list updation. I also have experience in excel worksheet development for various applications. I am sure I can develop the best excel worksheets for your giv Lisää

₹15000 INR 7 päivässä
(0 arvostelua)