In message
04**********************************@microsoft.com,
Linda Coeckelbergs <Li***************@discussions.microsoft.comProcla imed
from the tallest tower:
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....
"ChrisM" wrote:
>In message 29**********************************@microsoft.com,
Linda Coeckelbergs <Linda Co**********@discussions.microsoft.com>
Proclaimed from the tallest tower:
>>I am making a list in excel but now I am at line 65536 and can't go
further. Is there a way to make this list longer. I'm using excel on
a Mac.
What is the list of? 65.5K is a lot of rows!!
--
Regards,
Chris.
(Remove Elvis's shoes to email me)
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...
--
Regards,
Chris.
(Remove Elvis's shoes to email me)