Search Columns and return multiple rows.

  • Thread starter Thread starter KJ MAN
  • Start date Start date
K

KJ MAN

Hi,

I need a Control Box function to get info from the user, compare it to a
column of data on another worksheet, then return the full row of information
to another worksheet. The info will be matched multiple times and I need each
of the matches to be returned on different rows for user selection. My input
box is fine, I just need a method for finding the info, and returning the
multiple matching info. Can anone help?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Subscript out of range 26
Search multiple worksheets and return value to main worksheet 7
lastrow function help 6
Combine/Merge Rows, Multiple Worksheets 6
Searching a row one cell after another 5
method to split data rows to multiple worksheets. 1
Excel 2007: Return rownumber when text data on 3 columns match exa 1
Find match from 1st 3 columns and return the row number 6

Back
Top