Copy a Name to a Different Workbook.

Closed

Doug in New Orleans - 11 Jul 2010 à 18:14
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 13 Jul 2010 à 07:19

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?

Copy a Name to a Different Workbook.
Copy worksheet to another workbook vba - Guide
How to create a workbook in excel - Excel Forum
Workbook vba add - Guide
Vba copy data from one workbook to another - Excel Forum
Copy macro from one workbook to another - Guide

1 response

Réponse 1 / 1

rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 766
13 Jul 2010 à 07:19

Seems like you would need to use VLOOKUP.

Similar discussions

Copy worksheet from one workbook to another workbook in MS Office Excel

Create Multiple Workbooks With Template At Once

Working with multiple worksheets in a workbook

Copy Worksheet to another Workbook (unopened)

How to copy sheets from one work book to other

Similar discussions

Subscribe To Our Newsletter!