Creating Stock in and out data forms to take or remove quantities from an inventory sheet

Hi guys, I'm new here but desperately looking for some help after youtube tutorials have come up short.

I'm creating an inventory management system where the basis is a 'current stock' sheet in a pivot table that will be filled with all the items.
excel1.png

I figured out how to create a data entry form on another sheet by recording the macro in this sheet and then linking that macro to a button
excel2.png

So the data entry would go into the original stock sheet in image 1, but I tested it on a separate sheet as so
excel3.png

However every time I fill out the form in the data entry sheet in image 2, it overwrites the same row (seen in row 5 in example), even though I pressed ctrl and down key when recording my macro, how do I stop this?

Other than this I'd like to also know, is there away so instead of adding new data to the current stock sheet using the forms, can I create stock in and stock out forms that just edit existing data on the sheet? If so could someone please help me with this?
I'd be happy to paypal a little cash in exchange for some time and would be eternally greatful, thanks for reading!

Harriet

HI Joske920, Thanks for replying! I had no idea I thought it would take me the row under that, silly me.
Below is the code for the macro I recorded, I hope you can think of something to do with it

Please Login or Register  to view this content.

Hi Joske, sorry it's been almost a month, life has been crazy busy. I just used this for the project i was working on and it was great. Thanks so much for your help!!
If you have a paypal send me your address and i will send you a little money to say thanks if you like.