Help excel: click & automatically copy paste

Solved/Closed
Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
I need some help

Let's say I have 5 different tabs named London, Paris,... Each tab contains different kind of information about the cities: population, governement,...

sheet 1 is my overview sheet where in cell A1 you can enter via data - validation one of the five city names. If I click for instance 'Paris' I would like the information that's on the sheet Paris automatically filled in the overview sheet

and to further elaborate: what if when I click Paris, I only want to get on my overview sheet the population for paris

I hope this is clear

thanks for your answers

1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
See if this helps

=INDIRECT(ADDRESS(2,5,1,TRUE,A1))

2: is the row where population data is found in sheets
5: is the column where the population data is found in sheets
A1: is the sheet name to look for (London, Paris,... )