Hi All,

Happy Easter.

I need some help here, on how to write VBA code to input data, like a bank statement did.

here's the form that need user to input the name, date, amount debit or credit (could be both), and notes in it. This form will be in sheet "Input Form"
Form.JPG

and here's the recorded table, in a sheet "Statement"
Table.JPG

the idea is to copy/input the amount in each respective column, based on the date in the form.

thanks a lot for the help
warm regards,

Adrian