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.
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 this finished? I understand how annoying it is and can get this fixed for you quickly! Please see the sample I fixed. I look forward to working on this project with you.
Regards
ILYAS
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. Result will be excellent
Best Regard
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 zone. Looking forward to your response
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 after quality work that makes my client smile. I love in trial and I like to show you some examples that will make you confident to hire me.
Honestly I am new in freelancing world but not in data entry world. I have successfully completed 100+ projects for our local organizations. Now this is the time to work internationally and spread my fake all over the world. My educational qualifications and technology made me more qualified for any type of data entry job. All programs of MS Word is on my fingers & eyes including online data research.
So, if you hire me, I am ready to start your project immediately with full work plan. I like to give you the best output you have ever seen.
If you want, you can contact me through email and Whatsapp and any kind of communication methods. I’m eagerly waiting for your response.
Yours sincerely
Seun
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
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..
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 person to be offered that job
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 contact me if you are interested in my services and discuss it further.
Regards,
Lukman
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 48 and accuracy 99% and Certified Ms Office and expert in Excel and all the shortcuts.
Hi there,
I am an experienced MS Office user and programmer. I am very accurate in my work. I do follow instructions within a timely fashion.
I am proactive and enthusiastic about delivering positive results. I am proficient in computer technology especially Microsoft Office applications.I have exceptional organizational and time-management skills. I pay a lot of attention to details.
Willing to cooperate with you and I can start work ASAP.
Best regards,
Rasha