Lists for multiple files.

K

kooopa

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
 
Top