Problem with search/retrieve data

Why do you need a macro? A VLOOKUP or INDEX/MATCH would return details from another range.

You'll get quicker and more effective help if you post a sample workbook with as much detail as possible about what you want/need to do.

Regards

Hi, thanks for replying. I tried with VLOOKUP or INDEX/MATCH but didn't succeed to make it work. How do I post a sample?

Select the Go Advanced option and then click on the paperclip icon.

Regards

Hi, posted the file. Look forward to hearing from you. Thanks!