Results 1 to 8 of 8

Create database in excel?

Threaded View

  1. #1
    Registered User
    Join Date
    10-28-2005
    Location
    Colorado
    Posts
    8

    inserting worksheets & linking cells problems

    Hi -
    I could really use some help. I am trying to create a database of non-profit organizations in Excel. My thought is to create a workbook with Sheet1 being a Master List and Sheet2 through Sheet200 (for example) being the information for each individual non-profit (Organization Name, Address, Contact, Service Area, Phone #, Mission Statement, etc.). The Master List would display information from all non-profits listing down (with column headings listed at the top). Each individual sheet would be a template of all the individual non-profit information in a page view (with headers listing down the left of the spreadsheet and information in the corresponding cell to the right). I am assuming I would be able to reorganize the Master List in a number of differrent ways should I desire -- alphabetically by name, by service type (drop down menu?), by area, etc..

    Assuming that this is a viable method, here are my stumbling blocks ...

    1. I need a way to create 200 worksheets of my template (which I have not yet created, but am sure I can figure out with the aid of Excel Help) in the workbook without having to add them one by one via Insert>Sheet.

    2. I would need the information from Sheets 2-200 to be automatically entered into the Master List. I am able to link the cells by entering =Sheet2!B1 for example into the cell on the appropriate master list cell. Is there a way to automate the filling of subsequent cells below it with =Sheet3!B1, =Sheet4!B1, =Sheet5!B1, ... =Sheet200!B1? I have tried with Fill>/Series, but to no avail.

    I am sure there are more stumbling blocks ahead, but these are the two I have immediately identified. I began this process in an Appleworks Database, but will need many people to have access to it in the future and know a majority will not be Mac users. This last month has been my first experience with Excel and I am finding it a very adaptable program. I plan to continue using it in the future. Any help would be greatly appreciated.

    Thanks - Tom
    Last edited by wirthless; 10-28-2005 at 01:52 PM. Reason: specificity

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1