extract data

[crazydude80]

Hi ,


I have a raw data in sheet2. I need to find only a specific data which i saved in sheet1. How to extract those data and output it in sheet3 ? any macro with button clicks ? thanks in advance

[arlu1201]

Are there chances of multiple entries for each item in sheet 1? If no, you can get the results using vlookup in sheet 1 itself.

[crazydude80]

Are there chances of multiple entries for each item in sheet 1? If no, you can get the results using vlookup in sheet 1 itself.

yup.. there is chances of multiple entries. Raw data is in sheet2. just need to extract some files based on sheet 1 input.
How to use vlookup ? thanks

[arlu1201]

You will not be able to use vlookup if there are multiple entries per item.

[crazydude80]

ok. can guide me how to use the vlookup ? maybe useful if dont have multiple entries. thanks

[jraj1106]

Hi
Try this code:

Please Login or Register  to view this content.

Regards...

[tom1977]

Hi my proposition

Please Login or Register  to view this content.

[crazydude80]

thanks a lot guyz.. really saves my time.