Get data from CSV to excel based on the cell value in A1

[JohnsonFelix]

Hi team,

I have one input file (csv or text) format, Input file will contains numerous data, So I just want to extract data from Input file based on the cell value in A1 in another excel sheet.
When I paste in Cell A1 then all other information should get retreived from (csv or text)
Please advise how we can create based on VB Macro

 

[JohnsonFelix]

Hi experts,

Could someone help me on this.

Regards,
Johnson