I want to use excel to keep track of my book collection, but I have a question...

[slipandfall]

Hi,

I want to create a database of sorts using excel to keep track of my book
collection, but I have a question.

Essentially for each book listed on a row I want a column for each of the
following: book title, author, publisher, year, and genre.

I've used Excel before and have seen a spreadsheet with a worksheet like the
above which had a second worksheet that had a button marked "Add book
details" When you clicked it you filled the info above into a few boxes and
then it would actually add the info you typed in, into the first worksheet
and even sorted it into the correct position alphabetically.

How do I do that?

I understand formulas in Excel, but do I need to create macros to transfer
information from worksheet page to another? I'm over my head.

Can anyone recomend a site where I can learn how to do this or even a
template or site on the web where I can download a premade one that I can
customize. Miscrosofts template site doesn't really have any good examples
of inventory templates... Though I have in interest in learing more about
Excel programming, Id rather not have to reinvent the wheel.

Thanks in advance!

 

[Otto Moehrbach]

What you describe would take a macro, yes. But Excel has a "Form" feature
that would do, I believe, exactly what you want. With your table on the
screen, select any cell within your table. Now click Data - Form and see
what happens. Post back if you need more. HTH Otto

 

[Jay]

Just a thought. Excel is a very good data manipulation tool and
spreadsheet tool, but if you want to store data for easy retrieval,
access is the best program for that. They even have template databases
for book collections, with all of the fields that you are wanting.
Hope that helps.
Jay