Script query

  • Thread starter Thread starter KiwiBrian
  • Start date Start date
K

KiwiBrian

I have a 2000 row database with one column containing a number between 1 and
30, to enable the extraction of all records with the same number.
I assume that what I want to find/aquire/write is a script that will enable
the automatic (in one operation) extraction of the 30 different
mini-databases in the same folder as the source, and named 1.xls to 30.xls.
Can anyone give me any pointers as to how I might achieve my end objective,
and whether I am going about this the right way?
Thanks
Brian Tozer
 
Improved wording for clarification:-

I have a 2000 row database with one of the columns containing an index
number between 1 and
30.
This is to enable the extraction of all records having the same index number
into 30 seperate files.
I assume that what I want to find/aquire/write is a script that will enable
the automatic (in one operation) extraction of the 30 different
mini-databases, saving them in the same folder as the source, and named
1.xls to 30.xls.
Can anyone give me any pointers as to how I might achieve my end objective,
and whether I am going about this the right way?
Thanks
Brian Tozer
 
Even more clarification

I have a 2000 row database with one of the columns containing an index
number between 1 and 30 in every row/cell.
This is to enable the extraction of all records having the same index number
into 30 seperate files.
This is to allow the 2000 entries to be grouped into 30 different
categories.
I assume this would be reasonably straightforward using the Auto Filter, or
the Advanced Filter.
Instead of having to do it manually 30 times, I would like to automate it as
one operation, where each operation will save the selected records as a new
filename, e.g. 1.xls through to 30.xls.

Any help on what and where I should research this will be appreciated.
Thanks
Brian Tozer
 
Back
Top