Applying filters accross Multiple Workbooks

[pocquet]

Hi all, I am sadly using office 2010

I have two SEPRATE workbooks (Book1 and Book2)

Both workbooks have a similar filter for postcode(zip code for the USA)

I want to select a Postcode within book 1's filter and have that also apply to the filter within book2.

Any ideas?

Thanks

JC

 

[JLGWhiz]

Is this for manual operation, formulas or vba? If VBA then you could use a public variable that would have the same value in both workbooks.

 

[pocquet]

Hi,

I have to match data across two workbooks... Sadly it is address details and they are different (eg Street to ST).

So I have to manually look, I am trying to remove clicks by changing both at the same time.

 

[pocquet]

Hi,

Resolved this myself by doing a double click event.

Not pretty but works and has doubled my efficiency.

Public Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
    Cancel = True
'Change Target to Red To keep track on where I am in the List
    Target.Font.Color = vbRed
Dim S As String
S = Target.Value
With Worksheets("2015")
    .Select
    .Range("$A$1:$K$5739").AutoFilter Field:=11, Criteria1:=S
End With
Windows("tracker.xlsx").Activate
    ActiveSheet.Range("$A$1:$N$4305").AutoFilter Field:=10, Criteria1:=S
Windows("Matched Files.xlsm").Activate
End Sub

 

[JLGWhiz]

Thanks for the feedback,
regards, JLG