Copy a Name to a Different Workbook.

[Closed]
Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
Hello,

I want to create a schedule of workers from a list. Example: Workbook1 will have a list of workers with a column for monday-friday. I will have a separate workbook with a template with a list of routes for that week. I want to be able to simply enter a number for what position they will be working that week and it will populate the route template.

Anyone know an easy way to do this?

1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
Seems like you would need to use VLOOKUP.