Create an Account Mapping Software Interface within Excel using Excel VBA


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)


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


1 month


SGD $800

Taidot: Excel VBA, Ohjelmistokehitys, Englanti (Iso-Britannia)

Näytä lisää: import dat file using vba excel, script create account using excel, create lotto excel using vba, printdisplay using vba excel, create roster using vba excel, download file web using vba excel, starting program using vba excel, cut using vba excel, using vba excel clock, extracting xml data using vba excel macros, create contactless smart card interface using 2008, create quickbooks iif import file using vba, printing sheets using vba excel, inventory using vba excel, create income tax calculator excel using vba, how to create a data entry form in excel using vba, how to create stock control system in excel using vba full tutorial, how to create multiple sheets in excel using vba, lock a cell after data entry using vba excel with message box notification before locking, web scraping using vba excel

Tietoa työnantajasta:
( 5 arvostelua ) Singapore, Singapore

Projektin tunnus: #30043081

Myönnetty käyttäjälle:


Hi, PLEASE visit my portfolios for my ms excel vba projects I'm a expert vba developer and I'm so interested to work with you, Thanks dynamic user form using vba [login to view URL] Lisää

$750 SGD 7 päivässä
(7 Arvostelua)

27 freelanceria on tarjonnut keskimäärin $868 tähän työhön

(43 arvostelua)
(20 arvostelua)
(69 arvostelua)
(13 arvostelua)
(7 arvostelua)
(9 arvostelua)
(29 arvostelua)

Hi, I am well versed with Excel VBA and can help in creation of Accounting mapping software using VBA. It would help to discuss further on this along with few samples files. Looking forward to working with you. Than Lisää

$750 SGD 15 päivässä
(9 arvostelua)
(3 arvostelua)
(8 arvostelua)
(6 arvostelua)

Confident. Hi i am an Senior Excel VBA Expert. As 9+ years experiences in these field. I can give good quality work. I have read the guidelines of your work.I believe that i can provide you the best quality works you a Lisää

$800 SGD 10 päivässä
(10 arvostelua)

Hi there, Gone through your description and i can help you to create the account mapping software in EXCEL using VBA. I am a Microsoft Certified Professional in Excel and VBA as an Expert. Awaiting for your response Lisää

$750 SGD 30 päivässä
(5 arvostelua)
(2 arvostelua)

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

$800 SGD 30 päivässä
(5 arvostelua)

Greeting! My name is Vipin Kumar Garg and I am a software engineer and qualification is Master of Computer Application (MCA). I have 20+ Yrs. Exp. in MS Excel VBA (Macro) and I am from India. I have developed around 5 Lisää

$800 SGD 7 päivässä
(1 arvostelu)

Hi There, Greetings! I have read the project requirement very carefully and I have understand that you are looking for application which will handle the groups, account and user with the help of Addin and I am very sk Lisää

$800 SGD 5 päivässä
(2 arvostelua)

Hello, Greetings of the day! I am ready to Create an Account Mapping Software Interface within Excel using Excel [login to view URL] i checked all the requirements and i think I am totally fit into it and I will provide it with t Lisää

$1125 SGD 7 päivässä
(0 arvostelua)
(0 arvostelua)

Hi. I will create an account mapping interface within excel as per your instructions. I am a Software Engineer with 3-5 years of experience. I'll provide you quality work. Please award me this Project so that we can di Lisää

$750 SGD 30 päivässä
(0 arvostelua)