How to set up dynamic table using vba

[mhghg]

Hello ,
I just wrote the macro to update the sheet2 balance and date based on the data entered in sheet1.
My macro is working but I am a vba beginner so I am thinking if you can show me another way
to write it better. My problem is I do not know how set up dynamic tables so the data in sheet1 and sheet2 just continue to grow
Sheet2 has unique values for Name only

Thanks,

[protonLeah]

Title updated...

[protonLeah]

Please Login or Register  to view this content.

[mhghg]

Thank you very much, but you define table 3 and 4 for sheet 3 and 4 but I only has sheet1 and sheet2 repeated with different range. Also is there anothe way to re-write the script instead of hard coding the ranges?

[protonLeah]

Please Login or Register  to view this content.

[mhghg]

Thank you very much for your enthusiasm. Is there any one show me the steps to close the question with [Solved] tag again please.