Excel VBA Inventory Data Model and Automation

진행중 등록 시간: 4년 전 착불
진행중 착불

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

엑셀 비쥬얼 베이직 Excel VBA Excel Macros 데이터 처리

프로젝트 ID: #21316754

프로젝트 소개

14 건(제안서) 재택 근무형 프로젝트 서비스 이용 중: 4년 전

수상자:

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 기타

$150 USD (7일 이내)
(1 리뷰)
1.5

이 일자리에 대한 프리랜서 14 명의 평균 입찰가: $187

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 기타

$240 USD (6일 이내)
(364 리뷰)
8.0
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 기타

$250 USD (7일 이내)
(195 리뷰)
7.7
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 (3일 이내)
(363 리뷰)
7.5
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 (7일 이내)
(190 리뷰)
6.8
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 (5일 이내)
(138 리뷰)
5.9
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 기타

$200 USD (3일 이내)
(12 리뷰)
5.5
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 기타

$250 USD (5일 이내)
(41 리뷰)
5.6
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. 기타

$155 USD (3일 이내)
(7 리뷰)
4.3
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 기타

$140 USD (7일 이내)
(0 리뷰)
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 (7일 이내)
(0 리뷰)
0.0
Kristelljess

secretaria, manejo de excel, word, inventarios, kardex

$155 USD (3일 이내)
(0 리뷰)
0.0