Update entered data into a seperate sheet , delete entry field without affecting database

Hello,

I am a student and currently trying to get back into excel, after not having it touched for anything other than basic stuff in the last 4 years.


My Problem:

I want to be able to either add data by hand or automatically and then auto-populate a seperate worksheet/workbook. After I entered my data and the transfer is complete, I would like the entering field/array to clear itself, without affecting the transfered data. So basically once I confirm with enter or a button and I am done with adding my data it should transfer that data to another sheet, as well as clearing the entry field.

In addition I want it to connect to an if-function, so I can check the entered data I am entering against the database, which is being populated and check for duplicates. Once it determines the added value/data to be a duplicate I want the data not to be added, as well as give me a warning and give me an option to clear the field. Finally I want my if-funtion to stop the populating function, if there is nothing inside the entering field.

Finally the data should be added in the database sheet and automatically pushed one row down, so I am not overwriting my entered data.

My question:

Is there a way to accomplish this in excel or do I need python for sth like this? Could sb please point me to relevant sources, as I have been only able to find stuff about auto-updating sheets, where the data updates completly and basically would delete stuff. I would like to be able to comprehend all the neccessary step, so I can implement this stuff in the future myself.


Thank you for reading so far and I am happy for any suggestions.

Excuse me for any mistakes in my writing, since English isn't my first language.

Hello and welcome

Everything you outline above can be done in Excel by writing and using macros/VBA.

Attach a sample workbook showing your data layout and we can help from there.

Follow the instructions in the yellow bar at the top of the screen to help with attaching a workbook.

BSB