Add Value's in a new row in a table with a button

**saschah** · 05-21-2021, 04:25 AM

Hey!

I am working on a stockmanagement system in Excel.
I worked out most of it but to make it as easy to manage as possible i would like to work out the following:

I want to put values in some cells (darker green row).
Then with 3 different buttons (Buy, Sell, Reserve) I want to transfer the values into the right table in a new row.

So if i fill in all the values and I press buy the values are put in a table called BUY, same thing for Sell or Reserve.
With some simple formula's i get a overview table which gives me a insight in my stock per material.

After the "transfer" of the values the cells from which everything was copied (on top of the sheet) should be emptied so it is always clear where to put the next value.

I have put some snapshots of my file in attachment to make it more clear.

I am not very good with VBA so thats why I am here asking for your help

**torachan** · 05-21-2021, 04:44 AM

first observation - when working with tables do not extend them below or beyond the data (i.e. no blank rows) - tables grow dynamically with data entry.
to save us the time replicating your sheets please upload your workbook - see big yellow banner how to.
Welcome to the forum

Please attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

**saschah** · 05-21-2021, 05:10 AM

Originally Posted by torachan

first observation - when working with tables do not extend them below or beyond the data (i.e. no blank rows) - tables grow dynamically with data entry.
to save us the time replicating your sheets please upload your workbook - see big yellow banner how to.
Welcome to the forum

Please attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

Thank you for your help, I've added the workbook.
The link between the tables is now destroyed but its mainly about the action when you press the button.

**torachan** · 05-21-2021, 10:58 AM

There is a macro on the 'BUY' button.
To make the code shorter I have reordered the the columns to align with the header order.
The code for the other buttons would follow a similar pattern, to keep everything common I have used table data handling throughout.
The tables are named ("Tabel1" , "Tabel2" etc., .... "Tabel5").
Any queries post back on this site.
torachan.