Help excel: click & automatically copy paste

Solved/Closed
isabelle - May 12, 2010 at 12:13 PM
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - May 12, 2010 at 12:51 PM
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

rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 767
May 12, 2010 at 12:51 PM
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,... )
0