I have a sheet with individual countries listed and between the countries there is rows of data - i created a pivot table on a separate sheet and would like to select a country and add a macro that would take me to the specific row where the countries information starts - so I have 20 + countries on pivot and if I select austria I would like a macro to take me to row 52 ; Uk to row 62, etc.