+ Reply to Thread
Results 1 to 3 of 3

Tables Question

  1. #1
    Registered User
    Join Date
    10-29-2009
    Location
    Australia
    MS-Off Ver
    Excel 2007
    Posts
    1

    Tables Question

    Hi All

    i couldnt find anything like this but granted i dont entirely know how to search for my request:

    lets say i have 3 different data sets
    Months
    People
    Places

    now for those i would like a table where i can select the month and it gives me the list of people and places. i can then write down the amount of hours spend at each place.

    so as an example i select october 2009. it gives me something similar to

    People |Places
    ..............|Place 1|Place 2|Place 3
    person1.
    person2
    person3

    i have to capture information for 7 years. and i dont want a massive spreadsheet id like a small table where i can select the month from a dropdown and it just displays the rows/columns for input.

    can this be done?

    Thanks in advance

  2. #2
    Forum Guru teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,364

    Re: Tables Question

    Hi Kabookie,

    please take a few moments to read the forum rules. Then amend your thread title.

    You problem will be much easier to understand and solve if you attach a workbook with some sample data, describing what output you want where, based on what logic in plain words.

  3. #3
    Valued Forum Contributor
    Join Date
    07-21-2008
    Location
    London, UK
    Posts
    326

    Re: Tables Question

    You will have a massive spreadsheet. I mean data table

    Filter it..... across the table headers, to refine the data

+ Reply to Thread

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