Announcement

Collapse
No announcement yet.

vba import data from another workbook with auto filtered

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • vba import data from another workbook with auto filtered



    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, in "Consolidated History.xlsx" (sheet is Consolidated History) it needs to copy entire row only the name entered in Test.xlsx C2 and paste to "Consolidated History.xlsx" Sheet!1 A150.
    Both the excel files attached here.

    Anyone please send me the code for the above condition
    Attached Files
Working...
X