Matching the data from the Master List

[Jarvin24]

Greetings vba experts

Not only I am new with VBA - Macro, I also don't know what formula I need to do to have this template to run. So I am hoping if you could actually help me guys.

Here is the scenario:

I will be sending a blank excel from the custodian to confirm the physical assets (The master file should be hidden). The custodian will manually input the data (Asset Code: ex FUR1234) on the excel, then when he runs the Macro, the program should lookup on the unique reference (Asset Code) to input the Asset Name.

The Macro should also match the confirmation on the master file and determine how many are still missing.

Please see much detailed explanation on the excel file.

Hoping you could help me with this. ^_^

Thank you as always

[humdingaling]

Question
do you really need a macro to achieve what you are wanting?
all the hidden parts can be done prior to handing over to custodian


see attached formulas for what you are after

B14 has the unconfirmed total

[Jarvin24]

Hi humdingaling,

Thank you for your help, however, from my given example, the answer should be 3 Assets uncorfimed because only

FUR1111
FUR3333
FUR5678

was confirmed by the custodian. But goodnews is you have given me idea on how to resolve this. I'll try it first. Thank you so much

[humdingaling]

sorry misunderstood your question then
thought the exercise was to show any things missing from "hidden sheet"

if you wanted to know how many items the custodian entered, instead of countif just use Count formula

good to know given you ideas to solve yourself
if you need further assistance please revert