Hi -
I have spent most of today searching for an answer to this question and
have come up empty handed. Perhaps someone can help. I am trying to
create a database of non-profit organizations (and their information).

I would like each Non-Profit to have a page ... really a form or
template ... where all their information (Name, Address, Mission
Statement, Category -from pull-down menu if possible, etc.) could be
entered to the right of the topics (which are listed down the left side
of the page).

I would also like all that information to be linked/exported/merged to
a large master list that would have the information arranged in a list
(each sheet's info flowing across under the appropriate topic header
along the top of the page). I would also like this master list to be
sortable under each topic header -- alphabetically by name, by
category, etc.. I do not want to enter data into the master list; it
is for sorting and listing only.

Another way to look at this would be as if you were filling out a form
on a website (which might be a good thing for us to do in the future,
but is far beyond me now), who's data would then be collected on a
spreadsheet elsewhere.

Is this possible in Excel? Is it best to use a combination of Excel
and Word? How?

I know this is a lot to ask, but I could really use the guidance. I am
relatively new to Excel, but am enjoying it's versatility and plan to
use it more as I progress. Therefore, learning how to do something is
important (as opposed to having someone do it for me). Thanks. Also
know that any help is for my entire community as this document will be
for public use.

Thanks. - Tom


--
wirthless
------------------------------------------------------------------------
wirthless's Profile: http://www.excelforum.com/member.php...o&userid=28423
View this thread: http://www.excelforum.com/showthread...hreadid=480268