Using Command Button to Check Multiple Details from one Tab to Another Tab

[nelsonvivar]

Hello Guys,

I am trying to figure out how can I check employees withL
1. Same Departure Date and Time, Pick up Spot, Pick up Time and Land Transpo from Input Tab to Data Tab.
2. Then if have same details with other employees, a message will appear indicating "Same travel details with identified employee"
3. If no match: message- "No match found"

Thank you.

Attached is my draft database

[LJMetzger]

Hi Nelson and welcome to Excel Forum,

You were very close to a solution. The keys are understanding how Excel 'Find' works, which can at times be difficult at best, and understanding how Excel stores Dates and Times and Date/Time combinations.

You did several things correctly including:
a. Use of 'Option Explcit'
b. Creating the Concatenation in Column 'AB'.

See the following macro which is included in the attached sample file. The macro is triggered by the ' Check Employees with same Departure Details' CommandButton, the same as you did. My test data in the 'Input Sheet' may be in the wrong cells, if I misunderstood what certain fields were supposed to be.

Do not use my file except for test purposes, as I commented out some things that cleared the Input Sheet.

In ordinary Code module modDeparture:

Please Login or Register  to view this content.

Lewis

[nelsonvivar]

Hi LJ,

Thank you so much for your help.
Really works!