Search for content in cell from another worksheet, copy row, and pastevalue

Originally Posted by jraj1106

Hi

This can be done but few things not clear:
1. the value to be searched will be in wich cell?C3 or D3?
2. which column in sheet "data" has to be searched to copy the row?

Upload a sample file if possible...

Thanks for the quick reply.

My bad for the confusion, search C3. D3 was a typo.

As for the column. I need it to search all the columns. I have some codes that will search one column only, I will post that when I get near a computer on the morning.

Thanks!

Here are the codes and test file. It currently looks for the data in column A. But I need it to look in every column, or at least column A:CC.

thanks!

Please Login or Register  to view this content.

Try this one

Please Login or Register  to view this content.

thanks so much!. This almost works.

Only two things.

1. it seems that this pulls data from the entire workbook. is it possible for it to pull only from Sheets("Data")?
2. How do i make it so that i copys column A as well? It currently copies from column B.

thanks!

Please Login or Register  to view this content.

Perfect!!! thanks !!!!!

However I just realized something else. It's my own fault. What we have done here is to find matching contents in entire cells. Is there a way to match value in part of the cells?
For example if a cell says "c12, c14, c15" and I search the C12?

I do not know, but you can search for part of a cell

Change this line of code

Please Login or Register  to view this content.

In to

Please Login or Register  to view this content.

But this does the reverse you are looking for.

You are welcome!
Please close this thread as solved. Go in to the top right hand of this page, select, "Solved" from the "Thread Tools", drop down menu