UserForm Income / Expenditure Database?

Hi guys,

Good day. I am currently working on a new excel VBA database project where I have a userform for Income and Expenses calculations and upon hit the submit button I want the data to insert in an excel sheet named DataBase where I will have two tables for the respective Income and Expenditure.

The brief about my project is –

• I have created a userform to record and calculate “Expenditure and Income” of a business.
• The userform has various expenditure types and Income types along with quantity and amount.
• I want the data to insert (once hit the Submit button) in an Excel Sheet called DataBase (as you suggested). However I want the excel sheet to have 2 separate table as Expenditure and Income and the data should inset into the respective table.
• I have also inserted one TextBox in the Userform as a date field where I used Today function to record current system date to the both tables?

Can someone please help me how to achieve this? Please see attached the demo file. Also please feel free to manipulate it if you have a better idea…

Thanks.