drop-down lists/worksheets

Question

Is it possible to use the selections of a drop-down list to complete cells on multiple separate worksheets?

I have an enrollment worksheet, and I have 3 separate attendance sheets for 3 different classes. I would like to populate those attendance sheets with the names of people who correspond to the class selected in the drop-down list on the enrollment sheet.

Maybe I'm missing something and thinking too hard for this one. But if anyone has any ideas, I would love to hear what you think and/or know :).

Thanks,

Jeremy

Answer 1

Let's say I selected Tejido in cell D3, then in Tejido sheet what I need to populate and where.

Answer 2

I'm sorry, I explained it in English but the page is in Spanish.

So you can see under the "taller" columns are drop-down list options to select. I need those options to populate the "name" column on other worksheets.

Does that make any sense?

Answer 3

Can you please take an example of any input and corresponding output and explain me?

Answer 4

https://1drv.ms/x/s!Aj3JrdX-nu6KhQbENgh3ZP5X5IwX?e=hTLaxI

Let me know if this link doesn't work.

Answer 5

Hello SICR20

I am V. Arya, Independent Advisor, to work with you on this issue. The solution depends upon your workbook. May I request you to post the file with dummy data (no production / real data) to Onedrive or any other cloud sharing site and post the link here? If you need help about how to do - https://support.office.com/en-us/article/share-...