VBA ALLOCATION DATABASE POPULATION
- or -
Post a project like this1904
£500(approx. $624)
- Posted:
- Proposals: 14
- Remote
- #2277565
- OPPORTUNITY
- PRE-FUNDED
- Awarded
9574535495190114270269573552649865104128814494331449473206294624785852530560
Description
Experience Level: Expert
This project is to Populate the Allocations Tab based on several Business Rules from 2 other workbooks.
Allocation Tab is the tab which needs to be populated.
Tracker Tab columns BA is the code which matches the column on the Allocation Tab. Column DB is a concatenation of multiple text strings.
SDB Tab is the store allocation which can be a mixed of Numeric and Text. If a text value is present it =1. If the criteria is a mix of multiple columns it needs to add the Text value which = 1 to the numerical value in the column.
Business Rules 1 Tab tells you which columns to lookup from the SDB tab and stores that needs to be populated.
Business Rules 2 Tab tells you which row code that needs to be populated which is on the Allocation Tab.
Allocation Tab is the tab which needs to be populated.
Tracker Tab columns BA is the code which matches the column on the Allocation Tab. Column DB is a concatenation of multiple text strings.
SDB Tab is the store allocation which can be a mixed of Numeric and Text. If a text value is present it =1. If the criteria is a mix of multiple columns it needs to add the Text value which = 1 to the numerical value in the column.
Business Rules 1 Tab tells you which columns to lookup from the SDB tab and stores that needs to be populated.
Business Rules 2 Tab tells you which row code that needs to be populated which is on the Allocation Tab.
Zack C.
100% (55)Projects Completed
45
Freelancers worked with
8
Projects awarded
78%
Last project
10 Nov 2022
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies