Finalizat

Need Customization of my Excel sheet.

Job Description:

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".

Aptitudini: Excel, PHP, Procesare date, Visual Basic, Arhitectură software

Despre client:
( 13 recenzii ) AURANGABAD, India

ID Proiect: #35590790

Acordat lui:

rohitagarberg

Hi there..i am an expert in excel and can make the project for you immediately within few hours...thanks.

%selectedBids___i_sum_sub_4%%project_currencyDetails_sign_sub_5% USD în 1 zi
(798 Recenzii)
7.3

54 freelanceri licitează în medie 22$ pentru acest proiect

PERPETUAL0

Hello there Iam EXCEL 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. When do you need t Mai multe

%bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD în 1 zi
(206 recenzii)
6.2
rahulg5466

--------I CAN DO IT RIGHT AWAY-------- ⭐⭐EXPERT IN EXCEL⭐⭐ Dear client, I can help you with your project of data entry in excel, VBA, EXCEL MACROS, VB, building an excel file, excel dashboard, pivot tables, charts, v Mai multe

%bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD în 1 zi
(30 recenzii)
4.7
joicyarockiaraj

Ready to start ASAP. I have more than 6+ years experience in EXCEL & EXCEL VBA. I can make you the very best work completion with 100% accuracy in said time. Am fast and reliable who will complete in your budget.

%bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD în 1 zi
(33 recenzii)
4.4
ismail80196

I have read your project description and think I can help. Let’s chat in more detail about your project needs. Click on the "CHAT" button so we will discuss it in detail. I'm always online and available. Please feel f Mai multe

%bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD în 1 zi
(12 recenzii)
3.8
umairnoor32

Hello Sir, I have read your instructions and I can do it efficiently. Please give me this project. i will never disappoint you regarding your work and I will give you unlimited revisions with 100% quality work and al Mai multe

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% USD în 2 zile
(25 recenzii)
3.4
azizva

Hi I have done exactly similar project in recent days. I can help you to accomplish your task. I have relevant experience and skills as well. Inbox for discussion. Thank you. Kind regards Aziz

%bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD în 1 zi
(11 recenzii)
3.5
Josephhekal

Hello, I could help you Immediately with the functions to customize your Excel sheet, and will complete the work as per requirement ASAP. Also sample could be provided. I am a Data Scientist and Excel Expert. Have a Mai multe

%bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD în 1 zi
(12 recenzii)
3.3
Daksheshmahaur96

Hi There, As an Excel and VBA Developer, I can help you create DROPDOWN LIST & calculate the CLOSING STOCK and i can do this easily & quickly. I have also worked this type of similar project and i have more than 3 yea Mai multe

%bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD în 1 zi
(8 recenzii)
3.0
nournadam

Hello there, I am ready to work on your project, I have a good experience in Excel, Word, web search, data entry, and data processing, I am looking forward to dealing together, kindly contact me for more details. Rega Mai multe

%bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD în 1 zi
(3 recenzii)
3.0
urko92

Hello there, I hope you are doing well, Can you share the excel sheet so I can figure out the issue you are facing. Please message me. Best Regards: Zeeshan

%bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD în 1 zi
(8 recenzii)
2.1
akibul18

Hey there, My name is Akibul and I was glad you are looking for an excel developer. I will write vba code to automate your excel file. Thanks

%bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD în 1 zi
(3 recenzii)
2.2
MOHDABDULRAFE

Hi, This is Mohammed Abdul Rafe From Hyderabad, India. Ready to Work for you & Waiting for your response! whatsapp@9052638151

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% USD în 7 zile
(0 recenzii)
0.0
kubernandi

I have good hold in excel and have been in inventory management for more than a year now. I can make u an effective excel sheet to manage your inventory without any hassle.

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% USD în 7 zile
(0 recenzii)
0.0
Rohik80917

Hi there, I am expert in excel, I have a long time experience. I am read your project carefully, So I am interested in your project. I am waiting for your nice response Thanks

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% USD în 7 zile
(0 recenzii)
0.0
divyakamani

I have 4 year experience in excel. I do it very clearly. Please give me chance to prove my self. Thank you for supporting me.

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% USD în 2 zile
(0 recenzii)
0.0
ashokpuri2021

Hello there, This is something, I can't explain here. I have years of experience with VBA and excel. I can deliver your project within acceptable timing depending on your requirements and the level of complexity. So Mai multe

%bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD în 1 zi
(1 părere)
0.0
Kailamnsh

I am manish patel from gujarat. And i have a good expirience in aacounting and stock adjustment. Also i work in excel. So i am interested in this work

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% USD în 7 zile
(0 recenzii)
0.0
telawadepranav4

Hello there, I would like to accept your project. Financial calculations and excel output I am a professional Excel expert who can complete your assignment in time with 100 percent accuracy. I have more than 6+ years e Mai multe

%bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD în 1 zi
(0 recenzii)
0.0
Fatihahsukri31

Thank you for visiting my profile. My name is Nur Fatihah Binti Muhamad Sukeri. Dear Sir / Mam I think you are looking for someone for your project who can collect company name, address, phone number I'll provide you q Mai multe

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% USD în 7 zile
(0 recenzii)
0.0
haridaspawar111

I have done it for 4 years during my job I will do it very quickly for you Give me chance I will do it fast

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% USD în 2 zile
(0 recenzii)
0.0