Showing the last ten inputs based on criterias?

Hello.

I have a exceltool (attached) where users add events that has happened to their machine. Many operators and machines use the same document.
This is part of a follow up to see where we may have potentialls to improve.
The operators would like to always have displayed the last ten tool changes and which date, time and tool number that has been changed.

In the attached excel I have a table. Each column have already a dynamic named range to cover the full column. I don't know if that helps.
This table is part of a bigger document but I share this only so I can later alter what is needed.

Is there a way to make excel show the last 10 events based on a critera.

In the attached excel there is an example:
Choose machine number (5011) and the data is displayed in Colum R, S and T.
If you filter column F you will find the displayed data in the example.

Is it possible?

/Anders

Awsome!! That was what I needed!! Thanks very much!!

Hi again.

I'd like to alter the code so that I can change the machine number on another sheet called event.
How do I alter the code

Please Login or Register  to view this content.

so that it refers to the Event sheet?

/Anders