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