Paste in next empty row

[wegkruip]

dear sir/madam

i am working on a simple workbook but my problem is not that simple(at least it is not simple for me).

there are two worksheets "Transactions" and "Account Statement".

what i would like is a macro that will process the date, debits or credits enterded into "Transactions" and paste them below each other in "Account Statement"

See example attached.

looking forward to your replies!
thank you

[D_Rennie]

hello.

to get the last used row in a sheet.

Please Login or Register  to view this content.

Take a look at the attachment aswell

cheers

[royUK]

Looks like the ContactsForm example would be helpful

http://excel-it.com/vba_examples.htm

[contaminated]

Try this code. It works for me. Also I have uploaded workbook

Please Login or Register  to view this content.

[wegkruip]

thanks guys. thank you very much