MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.
Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range) If ActiveSheet.Name = "Payroll Data Input" Then If Target.Address = "$W$1" Then myvalue = Sheets("Payroll Data Input").Range("W1") Sheets("Pay Dates").PivotTables("PivotTable2").PivotFields("Pay Date Calender Year").ClearAllFilters Sheets("Pay Dates").PivotTables("PivotTable2").PivotFields("Pay Date Calender Year").CurrentPage = myvalue Call UpdatePaydatesPivot End If End If End Sub
|How do I select one row from one sheet and pass the row to another sheet in Excel?||22||70|
|Excel-Find duplicates that ONLY have paticular criteria in another column||21||35|
|Excel 2016 - Convert column of URLs to hyperlinks (individually or en masse)||10||24|
|Excel - click on a cell and have everything in another cell clear||13||31|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
17 Experts available now in Live!