I have two sheets one contains data validation (list) multiple city names and depending on the city name I want to open the pivot sheet Selection.ShowDetail.

Sheets("Pivot").Select
Range("G36").Select
Selection.ShowDetail = True

I want vba to look at the value in Sheet "Dashboard" Cell "G1"(Contains City Names) and then go to sheet "Pivot" and find the Specific City Name and then go down 35 Cells and show details (Selection.ShowDetail = True)

Much Appreciated.