vba import data from another workbook with auto filtered of specified name

[elsuji]

Hi every one,

I am new on this forum.

I have two excel files. one is "Consolidated History.xlsx" and other on is "Test.xlsx"

I created one command button on Test.xlsx and type the name (Senthil Kumar P) in cell "C2".when i press the command button from Test.xlsx it needs to copy the row's from "Consolidated History.xlsx" (sheet is Consolidated History) as per the name entered in Test.xlsx C2 and paste to "Test.xlsx" Sheet!1 A150.

Both the excel files attached here.


Anyone please send me the code for the above condition