As our existing Software is created using EXCEL VBA, we require the use of EXCEL VBA.
**(other programming language can be used provided that there is no compatibility issue when it comes to combine the mapping software with our existing Software created using EXCEL VBA)
ABOUT THE PROJECT:
A. Create an account mapping interface within excel to fulfil the following functions:
1. Lists of accounts with account descriptions, account values and account codes will be able to be mapped into groups and subgroups (folders where the account details will be stored)
a. We will come up with a list of preset groups/subgroups
b. The interface will need to have the option to add groups/subgroups later on
2. Groups and subgroups will be able to be sorted by category and mapped to our existing software’s excel sheets to autofill the data alongside other information based on the group’s mapping/category
a. After adding new groups/subgroups later on, we will need to have the option to assign them a particular category to auto-map the new data to the excel sheets.
3. The software will need to be able to store these codes and mapping for future use when importing new lists of accounts
a. Software users map the accounts with codes to their respective groups/subgroups for the first time.
b. If users import accounts with identical codes in the future, they do not have to perform the mapping again, and the software will automatically assign accounts with recognized codes to their respective groups/subgroups.
c. The interface will call out any unmapped accounts for user to assign to groups/subgroups
4. The software will need to be able to generate compiled lists in excel format based on grouping
a. Data is sorted into groups and further split into subgroups with the expand/collapse function
5. The software will need a properties function to toggle certain conditions such as:
a. Hide groups/subgroups where there are no accounts
b. Hide groups/subgroups where the account value = 0 etc.
B. Create a new excel ribbon tab where the buttons to call out the interface will be stored
27 freelanceria on tarjonnut keskimäärin $868 tähän työhön
Hi , This is Yesu ,I am VBA developer I can do this project ,I work on excel vba,outlook,powerpoint,word,web,apis I can give you the Project by given timeline ,Please contact me for further details Thank You