Hi, I have the following code that takes values selected via a list on a worksheet named "Trended P&L" that takes the value that's placed in cell D3 and uses that value to refresh a pivot table located on a worksheet named "Travel".
Private Sub Worksheet_Change(ByVal Target As Range)
Dim...