Yes and Yes. What is a "naming sequence" and to what do you want it
assigned? HTH Otto
"Poorvi" wrote in message
...
Is there anyway I can use information on an excel worksheet to create
multiple files? I have data on say 'Tab1'. I have subtotalled data by cost
centers. Can I get a new file created in excel for each cost center ? Can
I
have a naming sequence assigned to this?