View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
[email protected] kooopa@hotmail.com is offline
external usenet poster
 
Posts: 1
Default 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