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
Bookmarks