ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Lists for multiple files. (https://www.excelbanter.com/excel-discussion-misc-queries/229836-lists-multiple-files.html)

[email protected]

Lists for multiple files.
 
I am splitting my file made up of 20 worksheets into 20 different
files; 1 per worksheet.
These worksheets are linked with references and use common lists named
in the original file.

I need to make split while:
1- Keeping the link with the new file names (right now I would have to
do that manually).

2- Have the lists useable to all new files without having to open all
the files that link to the lists.

Thx



All times are GMT +1. The time now is 08:04 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com