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

[Saschah]

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 value in certain cells on the top of the sheet.
With 3 different buttons you can put these at the end of 3 different tables.

So, button 1 puts the vallues at the bottom of Table 1, button 2 in table 2 and 3 in table 3.
(Table 1=Incomming material; Table 2= Reserved material; Table 3= Sold material)
The values from these tables are then linked to a 4th table which gives a summary of the free stock.

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 am not very good with VBA so thats why I am here asking for your help

Thank you guys!

 

[My Aswer Is This]

When looking for help its best to always be specific.
Like you said:
I want to put value in certain cells on the top of the sheet.
Certain cell is not specific.
And when referring to Tables we need to know the name of the sheet and the Table name.
Now you said:
(Table 1=Incomming material
Did this mean the Table name is Table1 or Incomming materials
And is this only a one column Table if not enter value into what column of the Table?
Refer to Table columns as column 1 or column 2 not column A or column B which are references to sheet columns not Table columns. A Table is a range on a worksheet.

 

[Saschah]

When looking for help its best to always be specific.
Like you said:
I want to put value in certain cells on the top of the sheet.
Certain cell is not specific.
And when referring to Tables we need to know the name of the sheet and the Table name.
Now you said:
(Table 1=Incomming material
Did this mean the Table name is Table1 or Incomming materials
And is this only a one column Table if not enter value into what column of the Table?
Refer to Table columns as column 1 or column 2 not column A or column B which are references to sheet columns not Table columns. A Table is a range on a worksheet.

Hey,
Okay, so i made some snapshots of my file so it might be more clear to you.

The BUY, Reserve and Sell tables are the ones where the data should be inserted.
The Overview table takes all the data from each table and adds all the amounts of the same type of material. Like this I can keep track of the free stock of these materials.
Free stock = Bought materials which is not sold or reserved.

Also like this I can keep track of my buying and selling history

So I want to put some value's (text or numbers) in the input fields.
When I push the BUY button the values should go in the BUY table in the columns with the samen name, except the "AMOUNT" value should go in BOUGHT.
If SELL is pressed, the same should happen but for the SELL table and Amount values should go in SOLD
After pressing the button the input fields should empty so you know the data are inserted and you can't accidently add the data twice.


One thing I was thinking about is when material is reserved, it will eventually get sold, I am not really sure how to get the values from the RESERVE table to the SELL table easely. maybe by putting in negative values and reserving them?

I hope it is more clear now, if not let me know.
Thank you!

 

[Saschah]

When looking for help its best to always be specific.
Like you said:
I want to put value in certain cells on the top of the sheet.
Certain cell is not specific.
And when referring to Tables we need to know the name of the sheet and the Table name.
Now you said:
(Table 1=Incomming material
Did this mean the Table name is Table1 or Incomming materials
And is this only a one column Table if not enter value into what column of the Table?
Refer to Table columns as column 1 or column 2 not column A or column B which are references to sheet columns not Table columns. A Table is a range on a worksheet.

Did I make it more clear to you or do you need some extra information?