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.
Automatically run a macro when opening a workbook - Guide
Vba copy data from one workbook to another - Guide
Excel vba copy worksheet to another workbook without opening ✓ - Excel Forum
Transfer data from one excel workbook to another automatically - Guide
Copy formula from one workbook to another without workbook reference ✓ - Office Software Forum

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 a row from one worksheet to another, based on criteria

Lookup across whole workbook (muliple sheets)

Macro-Copy data from one workbook to another

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

Excel - A macro to create new workbook and copy data

Similar discussions

Subscribe To Our Newsletter!