Is it possible to have an excel macro to automatically save many files in
another drive with the specific name of each file in its own folder using a
simple code? Currently, we use an excel macro to format text files to an
excel file with subtotals and they are saved to their own unique folder.
There are approx. over 1000 files that are run through this macro each week.

Example, ABC company with customer # XXX00003 has 10 files that need to be
saved under drive M:\ABC Company 2007\ and DEF company with customer #
XXX00004 has 20 files that need to be saved under drive M:\DEF Company 2007\,
and so on. Currently, the files are saving to their own folders through the
macro using the function: where 'ABC Company' 'XXX0 0004', however, we need
to manually add this 'where' code for each group's name and customer# to the
macro.

I want to be able to not have to add in each new customer's name and number
code since new customers are being added to the macro constantly. Any help is
very much appreciated. Thanks, LW