macro which copies all column values based on specific string inputs

Hi,

I need a macro which copies all of the column values on the same row of a string for all the sheets in a workbook.

1.When an user inputs a string, the macro will scan each sheet searching for an exact match of the string then copies all of the column values on the same row of the string. If there is an empty cell, the macro will return an empty cell.
2. The macro should be able scan all of the sheets in a workbook for all matches.
3. The macro should be able to process more than one input at a time.

I appreciate your help.

I've attached a sample excel file.Attachment 165606

This will ask for input and then search all worksheets except "inputs" and return any found to the "inputs" worksheet...

Please Login or Register  to view this content.

I've been waiting for a solution for some time.

Thank you so much for your contribution!!!

You're welcome.

Hi dangelor,

Just wondering if you could modify this slightly where instead of an input box, the macro would receive its input from a list on the first column or any one column then output the values row-wise instead of column-wise (i.e., one string value per row with its values listed on one row across columns).

Thanks again.

Possibly...

Please Login or Register  to view this content.