Hi folks,
I'm trying to produce a catalogue of a few thousand items. Each
item is listed by it's name and has 2 further columns to the right
giving further description and a reference. This list is sorted
alphabetically by it's name.

What I would like to do would be to copy all items whose names
begin with the letter A (with their associated columns) to a sheet
called A, and the same for each letter of the alphabet. Currently I
have to do this by hand each time I make an alteration and it's a bit
of a pain.

In an ideal world I would like to be able to click a button and
this would be done automatically for all items, however a button for
each letter would be OK as I would just have to make sure that I
clicked all the letters I had changed.

Do you think this would be possible in Excel or should I think
about moving to Access? If it is possible then how please?

Thanks in advance,
Alistair



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/