Sorry for the late reply. I did some changes with the uploaded file. please check it.
Right now, my Column Headers are Groups A~D(ROW 1), but Column Header would not be unique as I am going to group some Control No. which is in ROW 2.
Control No. 111 to 113 Belongs to Group A. In this regard, I expect columns of B,C,D as result if I searched for Group A in the Result Sheet. (Which is not working right now)
Can you help me with the following:
1. How can I control the result location, right now the result is showing in the column of F. How can I make the result to be shown in B8.
2. The results only showing 1 Column, I am expecting duplicates column headers to be put in this file as I am going to group some data. Same Column heads could be too many.
Here is the active code for your reference:
Bookmarks