Copy a Name to a Different Workbook.

Closed

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

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.
Run macro on opening workbook - Guide
Macro to copy data from another workbook - Guide
Transfer data from one excel workbook to another automatically - Guide
Excel vba add sheet to another workbook - Guide
Vba copy from one workbook to another - Guide

1 response

Answer 1 / 1

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

Seems like you would need to use VLOOKUP.

Similar discussions

Copy Worksheet to another Workbook (unopened)

Excel - A macro to create new workbook and copy data

Macro-Copy data from one workbook to another

Lookup across whole workbook (muliple sheets)

Copy formulas across workbook

Similar discussions

Subscribe To Our Newsletter!