Find Jobs
Hire Freelancers

Excel VBA Inventory Data Model and Automation

$30-250 USD

In Progress
Posted over 4 years ago

$30-250 USD

Paid on delivery
Looking for excel vba expert to help write a vba macro for following logic: Steps: Setting the period (first and last column where code should be executed) 1. First column = Today's date + E1 2. Last column = Today's date + F1 Push out logic 1. Match the AZs (E8:E24) to Gap/Excess (B63:B77) 2. For each matching AZs, if there is a excess (above 0, positive value) push the value in push/pull section (row 8 to 29) out to next month 3. By pushing the value to next month should NOT create a gap in that starting month where the value originally was 4. Should NOT jump over the values in the future month if exist 5. If there is still an excess at the end (last column) mark the value under "Excess bucket" in the Raw Data sheet column Q Pull in logic 1. Same as Push out except pull in, if there is a gap (below 0, negative value) pull in the value from the future months so that current month is positive 2. If there is no value in the future month in the given period, check the excess bucket. Result Output 1. Output sheet and the column header is already populated. 2. Fill in the result of what moved, how much was moved and whether it was a push or a pull. List Loop 1. All regions code should loop through the values in A1 (data validation list) 2. One region is the region on the current active sheet. Please refer to attached workbook for exact reference. The code should be dynamic to not break by adding a row or a column. And if possible please use the latest functions/variables for excel 2016+ Fluent English is very much preferred *Please note that this project seems simple but it actually requires advanced skill in excel and VBA
Project ID: 21316754

About the project

14 proposals
Remote project
Active 5 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
Hello there, i'd like to work with you on this however due to the complex layout and moving of data I will have many questions to clarify everything so would be useful if you could be around for questions if you would like to work together, we can write VBA functions to handle all of this, chat with me if you would like to discuss more - Thanks, Steve
$150 USD in 7 days
5.0 (1 review)
1.5
1.5
14 freelancers are bidding on average $187 USD for this job
User Avatar
Hello, I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. Please visit : https://www.freelancer.com/u/schoudhary1553 I have excellent command over English. I am a hard worker, productive and worthy of your attention I hope, I would be the right candidate for this post. Awaiting an affirmative response from you. Kinds Regards, Sandeep
$240 USD in 6 days
4.9 (364 reviews)
8.0
8.0
User Avatar
Dear Employer, I have checked your Excel sheet and also have gone through your requirement. Just want to discuss few things but I will do your job for sure. I am an expert with over 12 years of experience and will do a perfect job asap. Please do check my previous reviews once for your kind consideration!! :) Thanks and Regards, Ash
$250 USD in 7 days
5.0 (195 reviews)
7.7
7.7
User Avatar
Hello, I’m an Excel/VBA expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.
$200 USD in 3 days
4.9 (363 reviews)
7.5
7.5
User Avatar
Please review my profile as i have relevant skills and experience required for this project. Kindly send me a message to discuss further. Thank you, Asad Khan
$250 USD in 7 days
5.0 (190 reviews)
6.8
6.8
User Avatar
Hi, I have understand the project requirement & interested to make inventory template for this project. Please send a message so we can discuss more & start the project. Thanks.
$80 USD in 5 days
5.0 (138 reviews)
5.9
5.9
User Avatar
⭐Hi! Thank you for the opportunity to bid on your project. I have gone through your project details. I am a senior developer with 8+ years of experience in C++, C#, VB, VBA, Excel, Access and I'm a good Engineer. And also I have many experience and good skill about algorithm development. I have top rank in hackerrank online competitions which is famous world best online coding competitions. So I am sure that I would help you on this job. I promise that I will do my best for you, sir. Looking forward to working with you, not only for this project but in the future too. Thanks again for your attention about my bid. Best regards.
$200 USD in 3 days
4.9 (12 reviews)
5.5
5.5
User Avatar
I am postgraduate with more than 6 years of experience in advanced excel based tools, inventory tool, web automation, macros, VBA automation, Google spreadsheets, Google scripting. I have completed similar projects, please have a look at my portfolio for more details. I have developed excel based automation tools for big brands like Ernst & Young and Landmark group also.. You can get your work done with highest quality at lowest price. Looking forward to work with you.
$250 USD in 5 days
4.9 (41 reviews)
5.6
5.6
User Avatar
Full time freelancer with more than four years specialization in Google Services (Sheets especially) . Can propose personalized solution for your business based on Google services with any third party API integration. Areas of expertise: - Google services like Google Apps Script, Sheets, Drive, Forms, Gmail, Docs, Calendar, AdWords, Maps, Charts, etc - Integration with third parties APIs; - HTML, CSS (custom UI, forms, SPA) - Javascript (inc. React.js, Vue.js) - Firebase (hosting, database, auth, etc); - Strong financial background; (ACCA) - Business processes analysis; (Audit with Big4) I am an expert financial modeller. I have built vast number of financial models but not limted to Credit, Equity, and LBO Models. I can build any type of model with varying complexities as per the project requirements. I have also, worked extensively on Trading and transactions comparables. I am an excel and powerpoint specialist and can help you with webscrapping and any type of automation in Excel and powerpoint using VBA.
$155 USD in 3 days
5.0 (7 reviews)
4.3
4.3
User Avatar
I have proficiency working with Excel and VBA. In my most recent work experience with Scotiabank, I had to apply my VBA skills to improve the current processes of the team and create new tools using VBA which provided valuable information in less amount of time.
$140 USD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
i am the best operator in 6 years techer and 2 years cyber cafe deserve this job in and i went this projectto be given to me thanks
$150 USD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
secretaria, manejo de excel, word, inventarios, kardex
$155 USD in 3 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
Seattle, United States
0.0
0
Payment method verified
Member since Jun 24, 2016

Client Verification

Other jobs from this client

Overwatch Related Work
$30-250 USD
Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.