Закрыт

I need an Excel Expert

I want to maintain a real-time stock quantity Excel sheet. The list of stock is entered in the Excel sheet. There are multiple columns in the Excel sheet named 'Live'. The columns are of quantity sold, issued, stock refilled, etc. I have tried using the formula 'vlookup'. However, that functions only for one sale of one day because it doesn't take up the next day's sale values of the same quantity (added in the Excel sheet 'sale'. In the vlookup formula, I am using the name manager formula for updating sales.

I have also tried using the 'Consolidate' option of excel by adding the sale of the next day in the same columns, however, the 'Consolidate' function is not working correctly and I am getting the current stock quantity in negative. Specifically, it is showing entries, 50% more than the actual sales (if I calculate it manually).

NOTE: ALL THE COLUMNS ARE TRIMMED, SO THERE IS NO ISSUE OF SPACING ERROR.

Навыки: Excel, Обработка данных, Ввод данных, Visual Basic

О клиенте:
( 0 отзыв(-а, -ов) ) Delhi, India

ID проекта: #34065111

40 фрилансеров(-а) готовы выполнить эту работу в среднем за ₹1288

PERPETUAL0

Hello Sir , 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 Больше

₹2500 INR за 2 дней(-я)
(160 отзывов(-а))
5.9
MamukaB

Good Day I can help to you with this sheet. I think it will be better if we solve all problems using macro. This is best way for this case I have 15+ year experience of Excel, Excel VBA So, you can trust to me. Resul Больше

₹1500 INR за 1 день
(31 отзывов(-а))
4.4
mpriyaranjan13

Hi , I am an experienced Python programmer with 5 years of experience is software and web development, design and implementation. I can deliver well within your budget and deadline. I'm willing to work in your time zon Больше

₹1050 INR за 2 дней(-я)
(4 отзывов(-а))
1.9
bebrainsmart01

Hey, I am an expert of Excel, I can complete your task within minutes. you can message me directly.

₹1050 INR за 1 день
(1 отзыв)
0.2
Prianshu6969

I am Ms Excel expert. I have full knowledge about Ms Excel. I have 2 year work experience of data entry in Ms Excel.

₹1050 INR за 7 дней(-я)
(0 отзывов(-а))
0.0
bismahfirdouse

i have good typing speed and i am diploma holder in computer. i will make sure you will be satisfy by my work

₹1050 INR за 7 дней(-я)
(0 отзывов(-а))
0.0
Kausik21

I am a certified data entry operator.. please give me a chance to prove myself..you would not be dissapo...

₹800 INR за 4 дней(-я)
(0 отзывов(-а))
0.0
emmaseun87

Hello, I would like to let you know that I’m an expert in data entry and have been working for more than 6 years. Hardworking and dedication is my passion that I always prefer to employ in my projects. I like to run a Больше

₹1000 INR за 7 дней(-я)
(0 отзывов(-а))
0.0
mayanktrivedivw

Hi , i can build a custom software for you , which can work exactly for what you are looking in excel file. There you can have whatever custom functionality you want to add which is not supported by excel . thanks

₹10050 INR за 7 дней(-я)
(0 отзывов(-а))
0.0
AnkurMadaan90

I am proficient in excel and have 5 years of experience to prove it. I can quickly analyze the issue and share my findings with you

₹1050 INR за 7 дней(-я)
(0 отзывов(-а))
0.0
shahid10a40

Hello.I am shahid.I'm a well skilled and hardworking data entry operator who completes and makes every given project [login to view URL],I've two months of working experience which helps me to to perform according to my cl Больше

₹1050 INR за 15 дней(-я)
(0 отзывов(-а))
0.0
gabrielariveroa

Hola buenas, soy esperta en excel y lo puedo ayudar en su problema , se uso se uso de formulas por lo cual lo puedo ayudar en lo que necesita

₹1050 INR за 7 дней(-я)
(0 отзывов(-а))
0.0
SAMINA21083

I will be able to do this quickly and I'm ensure that it works very well.. look for high quality, fast delivery, suitable budget. I can provide all what you need. kindly msg me I'm ready to start right away..

₹1010 INR за 3 дней(-я)
(0 отзывов(-а))
0.0
syed62426

i am willing to work it is a simple task that can be done on microsoft excel other vlook up formula.

₹1000 INR за 5 дней(-я)
(0 отзывов(-а))
0.0
Abdelaty00

good price for u against good review

₹600 INR за 2 дней(-я)
(0 отзывов(-а))
0.0
esunil5281

I will be best choice for your project. I am available 27*7 days for this project. I should thank full to you.

₹1250 INR за 7 дней(-я)
(0 отзывов(-а))
0.0
jadensbernard89

Hi Am Ben,a computer scientist and a programmer with 4 years experience especially in data processing,data management. I am very prolific especially in visual basic programming.i think I will stand out to be the Best p Больше

₹1050 INR за 7 дней(-я)
(0 отзывов(-а))
0.0
Lukman4273

Hello Sir, I have read your project details, I have finished working on it and I will give you an easy way for your excel file problem, a simple way but can answer your wish, I want to send a screenshot for you. Please Больше

₹1000 INR за 1 день
(0 отзывов(-а))
0.0
EnockMicheu

I am well experienced in Excel and other Spreadsheet Software with experience and long time practice to date.

₹1050 INR за 2 дней(-я)
(0 отзывов(-а))
0.0
Revathi2196

This is R. Revathi I'm presenting my candidature for the Data entry jobs and i have a 6 years experience as Executive level. I can complete your project as soon as you expected time with my ability of typing speed WPM Больше

₹1050 INR за 7 дней(-я)
(0 отзывов(-а))
0.0