See attached your file with some slight modifications: Linked cells for combox changed and columns reference for filter added.
Option Explicit
Sub Button6_Click()
Dim SalesWk As Worksheet
Dim DataWk As Worksheet
Dim SelectionA As Range
Dim SubRegion As Range
Dim Segment As Range
Dim Country As Range
Dim SelectionC As Range
Dim SelectionA_Col As Integer
Dim SubRegion_Col As Integer
Dim Segment_Col As Integer
Dim Country_Col As Integer
Dim SelectionC_Col As Integer
Dim WkRg As Range
Dim DispRg As Range
Dim LR As Integer
Dim LC As Integer
Set SalesWk = Sheets("Sales Dashboard")
Set DataWk = Sheets("DataSource")
With SalesWk
Set SelectionA = .Range("AAA6")
Set SubRegion = .Range("AAA7")
Set Segment = .Range("AAA8")
Set Country = .Range("AAA9")
Set SelectionC = .Range("AAA10")
Set DispRg = .Range("C41")
LR = .Cells(Rows.Count, DispRg.Column).End(3).Row
LC = DispRg.End(xlToRight).Column
Set WkRg = Range(DispRg, .Cells(LR, LC))
WkRg.Offset(1, 0).ClearContents
End With
SelectionA_Col = SelectionA.Offset(0, 1)
SubRegion_Col = SubRegion.Offset(0, 1)
Segment_Col = Segment.Offset(0, 1)
Country_Col = Country.Offset(0, 1)
SelectionC_Col = SelectionC.Offset(0, 1)
With DataWk
LR = .Cells(Rows.Count, 1).End(3).Row
LC = .Cells(5, Columns.Count).End(xlToLeft).Column
Set WkRg = Range(.Range("A5"), .Cells(LR, LC))
If (.AutoFilterMode) Then .AutoFilterMode = False ' REMOVE AUTOFILTER IF EXIST
With WkRg
.AutoFilter Field:=SelectionA_Col, Criteria1:=SelectionA
.AutoFilter Field:=SubRegion_Col, Criteria1:=SubRegion
.AutoFilter Field:=Country_Col, Criteria1:=Country
.AutoFilter Field:=SelectionC_Col, Criteria1:=SelectionC
.Offset(1, 0).Copy Destination:=DispRg.Offset(1, 0)
End With
End With
End Sub
Bookmarks