Recent content by Ehunt256

I try to be persistent enough to get and understanding of what I'm learning and I'm sorry for all the confusion trying to explain what I wanted to learn, thank you for your patience to helping understand this better. Yep, I think this covers it if there any issues I will chalk them to user...

Private Sub CommandButton1_Click() Dim sn As String Dim wsLog As Worksheet Dim lastRow As Long Dim currentTime As String Set wsLog = ThisWorkbook.Sheets("Log") sn = wsLog.Range("C1").Value ' Scan input cell currentTime = Format(Now, "mm/dd/yyyy hh:mm:ss AM/PM")...

Ok I worked a little with this and It's almost perfect, but I need your help. There are three thing's that can finish this for good. 1. The area to put the SN number or Scan is C1 "I already did this but some help can help me further understand this." 2. The first item is to check OUT first if...

I understand now this cannot be done via Formulas it needs to be done via VBA now I got a little experience with it so can it get help that method?

Ok I found a perfect reference Here is what I'm trying to create via formulas

Ah ok thanks sorry for the lack of knowledge

=IF(COUNTIF(Inventory!A:A, C1) > 0, "✅ Found in Inventory", "❌ Not Found") in the formulas how to make the check mark and x mark?

OK Thanks for all your help I'm confident that this one can work well.

Say what about a check list? So now I have an inventory sheet what if I just scan if it is on the list it conforms with a check otherwise it records the serial number. I see now to try to start smaller then try to build up to the current task.

1 Log Sheet =NOW() Just records time when something is entered =IF(COUNTIF($B$2:B2,B2) MOD 2 = 1, "Out", "In") It just leaves an "In" Thats it Everything else just accepts and no change So maybe I didn't explain well so the "Blue" sheet is the Log in and out sheet What I need it to do is...

Sorry I must be missing something I keep getting the same thing just time placed on all points and one in and that's it

Nothing seems to work right

I'm sorry but I'm not getting the results that is indicated. Nothing has worked The checkout sheet (Log) is where the lookup or search would take place, it would go to (Inventory) SN column D2 search If found It will be placed in the Scan column of the (Log) sheet and the =NOW for (OUT) will be...

I'm sorry for not fully understanding, but what you have here is both formula (Which I'm extremely grateful for) and VBA for advanced marco function. Thank you so much for taking the time to show me how to do this but my last question where to put the formulas?

THANKYOU SO MUCH for you help and response here's what I have now. I already completed an Inventory sheet. I can post that too if needed. Now what you sent is that VBA script or a formula for the button, sorry I got a little lost there. If what you sent is what is needed, then I can figure it out.