Populate data in a different sheet using VBA

[ravikumarg]

Hello,

I am trying to develop a simple tracker for my parents to manage their retirement expenses based on the fixed income cash-flows.

BACKGROUND
I am using MS Office 2013.

The sample tracker (attached) has four sheets. The first sheet gives an overview of expected credit(s) into their bank account that are not yet (manually) verified.
The second sheet allows them to easily record new bank deposits.

PROBLEM_STATEMENT
My problem is with the third and fourth sheets. I need to populate these sheets with the additional data needed for the tracker to work efficiently. I am looking for help to copy the data from the "Input" worksheet into the next empty row of the "FD_Master" sheet. Also need to auto-increment the FD_ID field.

I am confident that I can extend this logic to populate the "Payment_Master" worksheet, if I get any helpful pointers. I have pre-populated these sheets with some sample data for a better understanding of my problem/challenge.

Finally, I am trying to parse the records in the "Payment_Master" every time the workbook is opened to display the expected payouts from the fixed deposits that can then be verified against the various bank statements.

Appreciate any assistance with the VBA code to populate the "FD_Master" and/or the "Payment_Master"

Thanks in advance,
Ravi

[ravikumarg]

UPDATE: After mucking around these forum posts, I managed to populate the desired records using the following macro code. I would love to receive feedback on making this code more efficient/elegant or maintenance friendly. I have attached the working Excel spreadsheet for ease of following my logic.

Please Login or Register  to view this content.