In message (e-mail address removed),
Since 3 years I'm making a list of books and the most important thing
is that I can sort them alphabeticly, colomn 1 or 2 or 3 or 4.
For example:
Name of writer - name of book - name of publisher - sort of book
I know, some people have strange activities....
Gosh, 66 thousand books! That's a few...
You can't go beyond that many rows, and splitting the list across multiple
'pages' will mean you won't be able to freely sort by all those different
columns...
I'd agree with Miro that a simple database might be your best way forward.
In fact I'd say it IS your best way forwards as it is so much more flexible
and powerful than a simple spreadsheet for this kind of application.
Doing this is fairly involved, certainly more complicated than Excel and it
is probably a bit beyond the scope of anything that could be easily
discussed here, but if you have a copy of MS-Access (or any other simple
database program), have a look at the samples and helpfiles that come with
it and see if it makes any sense.
If you want some help with the database, maybe you could have a look in
'microsoft.public.access'?
The only other thing you could do, if you want to stick with Excel is to
sort the books into categories and put one on each 'page'
Say Fiction/Non-Fiction or Sci-Fi/Crime/Thriller or
Cookery/Engineering/Nuclear Physics (well, I don't know what kind of books
they are...)
Hope this helps...
