Very basic help request

[KiwiBrian]

I have a database that has 6 columns and 2000 rows.
Row 1 has 27 different types of category text entries.
I wish to create 27 different databases from the big one, each containing
all and only the rows/entries corresponding to each of the 27 categories.
Can someone give me a pointer as to the method, or the terminology that I
should Google for or lok in the Help for.
Very basic I am sure but not easy when one doesn't know the terminology.
Thanks for any help.
Brian Tozer

 

[KiwiBrian]

I have a database that has 6 columns and 2000 rows.
Row 1 has 27 different types of category text entries.

That should have read "Column 1 has 27 different types ........"

I wish to create 27 different databases from the big one, each containing
all and only the rows/entries corresponding to each of the 27 categories.
Can someone give me a pointer as to the method, or the terminology that I
should Google for or look in the Help for.
Very basic I am sure but not easy when one doesn't know the terminology.

Sorry for my error.
Hope that enables someone to help me instead of being confused.
Thanks
Brian Tozer

 

[Max]

That should have read "Column 1 has 27 different types ........"

Ahh .. I was going to ask you on that earlier "typo" <g>

If it is just a one-time creation ..
think using Data > Filter > Autofilter might be one way to go
to "cut" the original db by each of the 27 text cats and then
copy the filtered rows > paste special as "values" & then "formats"
into 27 sheets.

You just need to do it 27 times, one cat at a time ..

Try Debra Dalgleish's nice coverage on Autofilter at:
http://www.contextures.com/xlautofilter01.html

 

[CLR]

Hi Brian.........

You might want to take a look at Data > Filter > AutoFilter..........unless
you really NEED to split the database apart into 27 different ones, this may
do the organization you are looking for..........

Vaya con Dios,
Chuck, CABGx3

 

[Tushar Mehta]

My recommendation would be "don't." Don't create tables based on the
value of one column. Instead, use the many tools to summarize and/or
'slice and dice' the data as needed. Check out sort (Data | Sort...),
filter (Data | Filter >), PivotTables (Data | PivotTable and
PivotChart...), Group and Outline (again from the Data menu), Subtotals
(guess what menu) and the various Dxxx database functions.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

 

[Nick Hodge]

Brain

You could try a pivot table. If you then set the column A up as a page
field you will be able to run these automatically into separate sheets based
on each value (By taking the 'show pages...' option from the pivot table
toolbar). Don't know if that will help...let us know.

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)