Return Row heading by Column header and specific texted cell row position

Dear All,

Your expert advice requested.

I have a data set, in which Sheet 1 have a matrix of high level showing Engineer, Program and commodity relationship.

I have to create separate sheet for each program on sheet 1, each program sheet should have Engineer name and commodity name from sheet 1.

Multiple commodities and multiple engineers should be separated by definite structure.

Attached please find worksheet with input and output (manual) as expected.

Please please help......

Try the attachment...


say thanks, click *

HI Vikas,

Thank you very much or your efforts. Your solution is near to my expectation.

My requirement is, from Sheet 1 program should read Program name ie Prog 1, Prog 2 etc.
Then it should search for commodity and return commodity and respected engineer name to the specific program tab. For multiple commodities under the same program, a spcific set of rows to be copied at predefined interval.