Badge Inventory Report

[Shamz41]

Hi
I need some help on the VBA of this report. In the "scan here" tab. I will scan in the badge number in cell "A2". The date will automatically be timestamped into the "June 17" tab of the date which I have indicated in cell "B2" of the Scan Here Tab. (I have originally input a "Today" function in cell B2 but have removed it for trial purpose here).
I just need a small help on the VBA whereby for example if I change badge 1 to "assigned" status on the date of 2 jun 17, the time stamp is not showing on cell J113. It is showing up on cell J3. Any assistance will be greatly appreciated.

The VBA code is as follows

Please Login or Register  to view this content.

[sintek]

Hi shamz41

Just check if this is what you require, then will convert to Event Macro

Please Login or Register  to view this content.

Edited:

Please Login or Register  to view this content.

[Shamz41]

Hi
The VBA worked but I when I changed the dates in row 2 to July the code didn't work. I have the below formula in cell J2 onwards to auto input the date.

I also realised the time stamp input showed the date correctly but the time was set at 12:00 AM. I need the date and time to be the current date and time stamped when I scan in the badges.

Please Login or Register  to view this content.

[sintek]

Hi Shamz41

I don't get it....Help me understand so that i can assist.
You type in A Badge no in A2 and a date in B2......This code automatically goes and finds the date you typed in and the badge no and enters the date and time stamp in the corresponding cell..... Corrected the code to stamp correct time...see red portion of code....IF you go and change G2 to 01/07/2017 which then lets your formula convert all to Jul.....The code still works...See sample upload with results.
Put the code in Sheets("Scan Here") Module
Am i missing something?

Please Login or Register  to view this content.

[Shamz41]

Hi Sintek
It worked perfectly. Thanks man.

Can I check with you I have this formula from rows 599:603 to count the total. In cell G600, I need the formula to count any text that is not the word "Loan", "Damaged" and date input from the timestamp.

Please Login or Register  to view this content.

[sintek]

The date count is a bit tricky....because dates in excel are simply formatted numbers....The cell contains date and time....Not to sure hey. perhaps someone else can assist with this part...The below formula will count all occurences except the damaged and loan...

Please Login or Register  to view this content.