return multiple values across multiple sheets

[mido25x]

hi ,
hope some one can fix my issue ..


i have an excel sheet with VBA code to check the employee number across many tabs and return back the result.

but the problem is while using this VBA code to lookup all over the tabs when it finds the employee number it returns back 1 result and then stops not returning all the results

so i need someone to modify the code like in this vba when it find multiple results to return back the number with sum .


you can find my VBA code in module 1

attached the file for reference

 

[vletm]

mido25x
Please, do not duplicate Your thread.
This stays open.

 

[mido25x]

please can anyone help .

 

[vletm]

mido25x
You should learn to be patient - someone would help then they have time.
You should add more details to make it more interesting ... like sell it.
#1 hint: many times, it would be smoother to write own code than modify others code.
#2 hint: there should be more data ... You have given ... one Emp ID.