Hi,
I have already experienced on creating various excel template using macros and visual basics. Please find the details below.
1. Rent Template: Template created to calculate the monthly expense details of room members. VB Form has been created by accepting 16 members entry at once. Inputs will be stored in a separate sheet and entry of day to day expense will be calculated based on the person which we select (Check box)
Main page will have the dashboard and report options to view the details in chart format for individuals as well as for the individual expense like Food, Provision, Movie, Petrol and so on.
2. Template to Calculate Profit Percentage: Template created with certain input requirement from customer like conversion rate, total leads and transaction details in order to find the turnover and profit details. Enabled the option to multiple with specific percentage based on the input values and there is a chart dashboard enabled with radio button option to display the chat comparison with each input and output data.
I hope i can able to create the expected outcome based on your requirement. Please let me know the additional details if you wish so that i can start working on it to fulfill the expectation.
Regards,
Dheepak Krishnan