Help excel: click & automatically copy paste
Solved/Closed
isabelle
-
May 12, 2010 at 12:13 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - May 12, 2010 at 12:51 PM
rizvisa1 Posts 4478 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
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
Related:
- Help excel: click & automatically copy paste
- Excel mod apk for pc - Download - Spreadsheets
- Number to words in excel - Guide
- Gif in excel - Guide
- Kernel for excel - Download - Backup and recovery
- Excel marksheet - Guide
1 response
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
May 12, 2010 at 12:51 PM
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,... )
=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,... )