Search Function, ROW WISE Results to COLUMN WISE Results

The file attached was retrieved by me through browsing excel forums. I apologize if I couldn't give credits to the one who made this file as I cannot find anymore to where I got this excel file. Anyway thank you very much, it was really a big help to me.

I run the system using search button in the Sheet2 and currently, the working function is through the input of information in Sheet2(Result) C5 as Search Bar where you can put and search any criteria mentioned in Sheet1(Table) Column A, results will be generated in row wise. For example Input Value of "A2 (which is '1')" then information ROW WISE in "A2", "B2", "C2", an so on will appear on the Sheet2.

However,can anyone help me to reverse the function from ROW WISE to COLUMN WISE results. Criterias to be input would be in ROW 1 Details and the expected result should be the whole details of a Column and as long as it could be. Thank you very much for reading this post.

Criterias to be input would be in ROW 1 Details and the expected result should be the whole details of a Column and as long as it could be.

Can you show your above expectation in a excel sheet ? thanks.


Regards,
DILIPandey
<click on below * if this helps>

Thanks for replies, For your reference also, the original codes I have right now is below:

Please Login or Register  to view this content.

The search results gives me a ROW wise results based on the Column A values. But now, I needed to disregard Column A as my criterias and will be used Column headers instead. I really need to have a column wise result upon searching on any values of column headers. The bottom line is that "to find headings and copy entire column in another sheet" Can anyone help me, please. Thanks!

Yes, I run the code with the button in Sheet2. I removed the old code but I don't know why it is not working.

Sir, thanks for you reply. It is now working but the data that were taken are the data in a row which will be transposed into column. I really needed to take the entire column values. Related to that and based on your code I come up with this code:

Please Login or Register  to view this content.

I have seen that I already copied the entire columns as I tried to paste somewhere after clicking debug. I want to paste it in F1 if possible. Can you help me with this. Please.

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:

Please Login or Register  to view this content.