Hello,
I am creating a spreadsheet where on the 1st sheet i have some data that looks something like this :
- on cell A i have some names and surn names
- on cell B i have the date birth
- on cell C i have the phone number, etc.
Now on the 2nd sheet i have created i have managed to make a dropdown list with all the names and select the one i want but i would like some other cell (like the phone number and birth date) to be filled automatically based on my selection.
Any idea how can i do this ?
Thanks in advance