Hi all,

Just need help with listing and finding in Excel. Have a list of names and it contains supervisors, operators and trainers. But some times I get trainers in the middle of the list.

So need a macro or VBA code, from the NAME TAB if there are trainers then find under trainers and COPY them in the next sheet after the supervisor list. But if there are no trainers then it should give return 0 at the end of the supervisor list.

Have attached the file.

Any help highly appreciated.
Dulanfile.xls