Add cell values to table

[Koert3]

Hello,

I am wondering how I can make a macro that adds a cell value to a column of a table. I have an excel sheet that creates invoices. But I want to save the date, the price and the number of the invoice in a table in another sheet using VBA.

I got 2 pictures so it is understandable what I mean.

Kind regards!

invoice_example.png
table_example.png

[pjwhitfield]

Create a button and add the following code (you'll need to amend sheet names and range values but it should work

Please Login or Register  to view this content.

[Koert3]

Thankyou!! It almost works. But after I tweaked it a little I got an error and I do not know how to solve it. I posted the error in this message. Can you tell me what is wrong?

Attachment 797638
Attachment 797639