Copy filter data from Master workbook to Result workbook

Hi,

We have two separate workbook in different location

1. Desktop Workbook Name - Master
2. Desktop Workbook Name - Result

In master file we have data in Sheet1!A1:H600

required a vba which import all filter data which match "Result workbook Sheet1!A1 data" with "Master Workbook Sheet1!C2:C"

suppose in Result workbook Sheet1!A1 = Ronaldo
then select all data, filter through C column, filter criteria "Ronaldo"
copy and paste values in Result workbook sheet1

we have same header in both workbook

find the solution, little different, but work in my case, pasting solution here so if anyone required, he can check

HTML Code: 

it will be more helpful us, if we can Type the filter criteria in a cell

To place filter criteria in a cell, say C1 = "Ronaldo" then

Please Login or Register  to view this content.

Thanks maniacb

its working perfect

Hi maniacb

can we do this

.AutoFilter field:=5, Criteria1:=[C1].value
.SpecialCells(xlCellTypeVisible).Copy

can we change Criteria1:=[C1].value
to
C1 to
Workbooks("BackTEst.xlsx").activesheet.Range("A1").Copy _
MasterWorkbook.Worksheets("Master").Range("A1")

or

C1 to workbooks("BackTEst.xlsx").activesheet.range("A1")

Yes, you can change it, but make sure workbook BackTEst is open.

Hi maniacb

but there is some problem in my formula, when we try to get the data in c1

Workbooks("BackTEst.xlsx").activesheet.Range("A1").Copy _
MasterWorkbook.Worksheets("Master").Range("A1")

or

workbooks("BackTEst.xlsx").activesheet.range("A1")

Hi maniacb

Done with some changes, thanks for your guideline and giving me motivation to do this

HTML Code: