Export Name Manager from one excel workbook and import to another
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
Hi, I'm not sure how exactly
Hi,
I'm not sure how exactly you separate your workbook, but if you use function Move or Copy... from the worksheet's right-click menu, when you moved or copied the worksheet, all relevant Names are moved or copied with the worksheet.
If I missed something, please explain in more details.
Best regards.