autocomplete cells with names from another worksheet

Occasional Visitor

Hi

Does anyone know it this can be done.

I need to complete a grid to allocate workers to tasks so i have my worksheets but need to know if  i can have just 1 worksheet with names on and then autocomplete the names on the other sheets as i type

please be gentle still learning about excel

1 Reply

@robdwells1963 

 

OK, being gentle, the task you've asked about--autocomplete from another worksheet--is possible (although the more accurate term would be that you'd be using "Data Validation" to create a dropdown list of the names, from which you'd pick the correct one (assuming these are all in the same workbook, just on different sheets within that single workbook)....

 

Here's a good link to learn how that works: https://exceljet.net/glossary/data-validation

 

Feel free to come back for more help if you wish.