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.
Vba copy data from one workbook to another - Guide
Vb net add sheet to excel workbook - Guide
Transfer data from one excel workbook to another automatically - Guide
Run macro when workbook opens - Guide
Excel - A macro to create new workbook and copy data ✓ - Excel Forum

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

Create Multiple Workbooks With Template At Once

Copy Worksheet to another Workbook (unopened)

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

copy data without opening workbook using vbscript

How to copy sheets from one work book to other

Similar discussions

Subscribe To Our Newsletter!