Showing most recent submissions to database in different sheet based on date/time

Hi All,

I am working on a Userform that that stores data in sheet called 'Database' with the option to edit that row of data later on while keeping that data in the same row. When data is submitted (or edited first and then submitted) the code adds the current date and time in column P. Now i want to add a sheet that shows me the 10 most recently submitted (or edited and submitted) rows (just the values, because there is also calculating columns in the 'Database' sheet). however, no matter what i try, it messes with the functionality of storing and editing the data and it does not show the 10 latest entries based on the submit date/time in column P. Help would be appreciated

EDIT:

i thought it would be easier to insert a new module and add a button to the new sheet called 'RecentEntries' where it loops through column P to select the 10 most recent dates but for some reason it does not work. Here is the vba code for the button:

Second edit:

SOLVED it myself, working code is below.

Please Login or Register  to view this content.