In Progress

Excel VBA Inventory Data Model and Automation

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

Skills: Excel, Visual Basic, Excel VBA, Excel Macros, Data Processing

See more: excel vba inventory projects, excel vba look data sheet, excel vba refresh data moves right, excel vba copy data explorer, excel vba post data web site, pricing custom excel vba inventory control program, excel vba create data file, excel vba add data, excel vba import data csv file, excel vba code data web page, excel vba chart data, excel vba copy data internet explorer, examples excel vba inventory, excel vba extract data web page, right excel vba seismic data, excel vba inventory programs, excel vba combine data, excel vba extract data pdf

About the Employer:
( 0 reviews ) Seattle, United States

Project ID: #21316754

Awarded to:

Nookster

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 More

$150 USD in 7 days
(0 Reviews)
0.0

19 freelancers are bidding on average $173 for this job

schoudhary1553

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. Pl More

$240 USD in 6 days
(338 Reviews)
7.9
asin1987

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 More

$250 USD in 7 days
(177 Reviews)
7.6
P0L

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
(313 Reviews)
7.3
wsh2

Greetings from Easton PA, USA.. {smile} Highly experienced (25+ years) MsEXCEL/SQL/VBA Business Information, Programming, and Database expert with GURU / MENTOR level technical credentials at [login to view URL] More

$212 USD in 7 days
(52 Reviews)
6.4
asadkhan3533

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
(147 Reviews)
6.5
mateenbhatti94

Dear sir I have read the requirements and completely understand the project.I will build you a fast macro that will do this job accurately and give you required output. I have been in this industry for 1 year and such More

$150 USD in 1 day
(75 Reviews)
6.2
aubrey03

I am an Excel and VBA specialist with a lot of experience in creating complex automation tools, formulas, databases, queries and macros. You may check some of my projects here: [login to view URL] More

$180 USD in 3 days
(128 Reviews)
6.0
leemilun

⭐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 More

$200 USD in 3 days
(12 Reviews)
5.5
StormLion227

Hello. My name is Marko and I am an Engineering Graduate with an MBA degree. I am a full time freelancer and I will work hard on this till completion. An Expert VBA programmer on freelancer.com and I do not bid on More

$155 USD in 3 days
(22 Reviews)
5.1
bhupendrayadav

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, pl More

$250 USD in 5 days
(33 Reviews)
5.1
Itblast

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

$155 USD in 3 days
(7 Reviews)
4.2
rashedkhanrubel

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
(20 Reviews)
4.1
finest2019

Dear client. Here is data processing manager. I have just read your requirement at carefully. I'm an expert of data processing by using many Excel macros such as DAX, pivotTable managing and excel VBA. I have good skil More

$140 USD in 7 days
(5 Reviews)
3.3
thepali

Hello, I checked your project carefully. As a senior developer, I have experienced for 10+ years. I and Our team members are young and talent developer. Our major development fileds are C++, C#, ASP.NET, PHP, Ionic/Rea More

$140 USD in 7 days
(3 Reviews)
2.5
SashaMorozov

Hello. I have read your description and I am so interested in your project. I am confident in your project and I can finish it clearly on time. I am well experienced and skillful C and C++, VBA, ASP.Net, Java, C#, QT More

$99 USD in 4 days
(1 Review)
1.0
reimoo7

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 More

$140 USD in 7 days
(0 Reviews)
0.0
chaurasiyarajesh

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 Reviews)
0.0
Kristelljess

secretaria, manejo de excel, word, inventarios, kardex

$155 USD in 3 days
(0 Reviews)
0.0