Macro search value in column and paste all the rows with this value..

**feroguz** · 11-09-2012, 02:23 PM

Hi! Good Morning!!

I need that when you put a value in range "A4: A", find the value in the "Sheet 2" and return me in "C3:C" all the values to find..& paste the entire row.
Is this possible?

Attach the document, when I try to create.
Thanks again!

Best Regards!!

**feroguz** · 11-09-2012, 02:24 PM

example.jpg This is the idea..

**feroguz** · 11-12-2012, 12:34 PM

I will pay anyone who writes the program I have described $20 (USD) via PayPal upon completion.

**jaslake** · 11-12-2012, 03:30 PM

Hi feroguz

I'm unable to figure out what you were doing with the UserForm so it's been left untouched.

I've added DataValidation to Range A4 through A14 on Sheet1. Select an Item and Data is pulled from Sheet2. There's new code in the Sheet Module and in ThisWorkbook Module and in the PrepData Module. A Named Range has been added in Sheet Lists (a new worksheet I've added). This Named Range is used for Data Validation mentioned above.

Take a look...let me know of issues.

**feroguz** · 11-15-2012, 12:57 PM

Dear John!

Works Fine!!.. Great Forum Guru

!!

Best Regards!!

Send you MP

**jaslake** · 11-15-2012, 04:23 PM

Hi feroguz

You're welcome...glad I could help. Thanks for the Rep.
Send the $20.00 to your favorite Charity...better yet, if you have Children, buy them a treat on me.