Adding new records in table and sorting it.

Hello everyone,

I am tried to make a pretty simple form for my small company but I do not know exacly how to do it.

I written the "core" of what I am trying to achieve. The main goal is to have a user operated sheet 'New_records', and user is only selecting things listed here - 'cat.','name','type' should be selected from list (according to viable options in 'helper' sheet), 'qty' and 'price' should be typed by hand, and if it is possible date should be changed according to real time (but also with possibility to change it into past one)

And at the end of it - after pressing button, this new record should go to the table in sheet 'All_records'.

I tried to do it on my own in VBA, but I am lost cause - I have no idea how to do it. Is there anyone who can help me?

Best Regards!

Hello.
Here is another way:

Please Login or Register  to view this content.

Awesome! Thank you guys.

Didn't hear about user form before, but BeyondExcel did exactly what I was thinking about. But only one more question, how to change date to european standard (dd.mm.rrrr)?

.
Your comment confuses me. We'll see:
- Dates are presented to me in "cell G3" as day/month/year.
- And when a record is saved I see it in the same way: day/month/year.

Could you tell me how you see both situations?

Hello,

Screenshot_5.png

this is what I see in 'new_records' sheet, and after saving it changes into 30.08.2022

Works really great! Thank you for your help.

I have last question for you. Can u make that every time I add 'sell' record it will add to table average price from table? But actual value at the moment of adding record - becasue I do not know where table with this value will be I just set up a temporary solution in example and I hope i will know how to edit code to add more variables to all records/change positions of exisiting ones.

Thank you very much again.

.
Hello.
I modified the Helper sheet table

Taking this information into account, indicate in column G (of the Helper sheet) which of these rows will contribute their respective data to the Avg. Price column of the All_Records sheet.

Sorry, but I think I do not understand it. I want to have a circle like in attached jpeg - is it possible to be done? Or maybe you will tell me if there is a better soultion than what I want

Attachment 794802