Matching multiple criteria in all sheets and returning values

Are all sheets concerned or is there a list where to search in?
Where to put the data ?
Of course a short example will help

See the example attached and comment

Hello PCI !!!

You were almost perfect, but can the "Arg1" be a range like say E1:E10 so that I can search for all the employees, not just for an individual and get values against each name.


And Yes, all the sheets are concerned, except the Sheets "Index" and "Emp List". I am putting the data in "Emp List" sheet itself from "Column AB6".

I have attached example sheet bit modifying what u did earlier.

See remake attached

See attached

Another run with the selection of the transaction

PCI

Everything runs smoothly...EXAMPLE SHEET2 IS simply awesome, however, only for ELE transactions, data is in column M; for CCP it is in H and for FAA it is in I...they change based on transaction(sry for that)...so ur 2nd example sheet is awesomely coded but I cannot use it...I am stuck with Example sheet 1 and I modified code for various transactions..basically I wrote additional macros changing Arg(s).


Now, is there a way, where I can add hyperlink to the values, so that when I click on a value, it jumps directly to that sheet???

What if I hide some rows where I am putting the data i.e EMP LIST...say if I hide B to H columns,then should I keep changing the ff.offset value.. (Example Sheet1)??

"What if I hide some rows where I am putting the data i.e EMP LIST...say if I hide B to H columns,then should I keep changing the ff.offset value.. (Example Sheet1)?? "
NO don't change anything, it works like that
"hyperlink to the values"
It is another story in the way the code has been prepared, it will be easier to prepare another macro to do this specific job, open another thread to avoid mixing the topics.