How do I create a vehicle database

[T Macg]

I am so new to excel that I don't even know where to start,I wish to create a vehicle register/database that will tell me when Previous dates and times a vehicle entered a specific location when I type in the registration number are there templates available or somewhere I can learn how to create this myself all help will be very much appreciated

Thanks in advance

Tam

[FDibbins]

Hi, welcome to the forum

You need to change your titel to something that actually describes your problem. Thing is, Im not really sure what you want, so I cant even suggest anything to you

Could you walk me through (in simple terms) what you are doing, and what you want to achieve?

[T Macg]

hi thanks for the reply basically what I am trying to do is when a vehicle enters our site I will enter the registration Into a database so the next time the vehicle enters when I put in the registration it well tell me when they were last in the site including date and time .

[FDibbins]

Thanks for the title change

That sounds do-able. Have you started putting anything together for this yet?

[T Macg]

Not at the moment not quite sure we're to start to be honest

[Jed_Guinto]

Hi,

It looks like you want to create a search database but one that updates itself. It looks like you may need to design a VBA Macro code in order to do this.

What the Macro will do is search through your records to see if there's any matches, then check for the latest date and time. If there are no results then a message will come up saying "No result found"

I would suggest to first create the table you're looking to search in and fill it in with some values so we have an idea of what we are working with.