Export Name Manager from one excel workbook and import to another

**davisfs2007** · 09-22-2012, 09:11 PM

Hi,

I had a workbook with the following tabs of reports/data:

Employee Detail Info,
Wk1 Detail Time Sheet,
Wk1 Recap,
Wk1 Invoice,
Wk2 Detail Time Sheet,
Wk2 Recap,
Wk2 Invoice,
Payroll Working File, and
Payroll Summary.

The file was sooo big and was taking too long to process because of all of the formulas, so I decided to separate the tabs in the following workbooks:

A. Employee Detail Info,
B. Week One Detail Time Sheet,
C. 1) Week One Recap and
2) Invoice,
D. Week Two Detail Time Sheet,
E. 1)Week Two Recap and
2)Invoice, and
F. 1)Payroll Working File and
2)Payroll Summary.

A feeds B-F
B feeds C.1),2)
D feeds E.1),2)
C and E feeds F.1)
F.1) feeds F.2)

The problem I am having is the updating Name Manager for ALL TWELVE tabs..... I have far too many to update individually per workbook. How can I speed up the process? Is there a way to simply COPY the Name Manager from one workbook to and PASTE it to the Name Manager in the other 5 workbooks??

THANKS

**protonLeah** · 09-23-2012, 01:37 AM

see:
http://support.microsoft.com/kb/213389

**davisfs2007** · 09-23-2012, 09:45 AM

Originally Posted by protonLeah

see:
http://support.microsoft.com/kb/213389

Thanks protonLeah, is VBA the only way?

**protonLeah** · 09-23-2012, 03:50 PM

All you need is a loop to process each workbook in a list:

Please Login or Register  to view this content.

Copy the Excel VBA code
Select the workbook in which you want to store the Excel VBA code
Hold the Alt key, and press the F11 key, to open the Visual Basic Editor
Choose Insert | Module
Where the cursor is flashing, choose Edit | Paste

To run the Excel VBA code:
Choose Tools | Macro | Macros
Select a macro in the list, and click the Run button