Cost Sheet

Discussion in 'Microsoft Excel Discussion' started by oibobadilla@gmail.com, Jan 29, 2008.

  1. Guest

    I'm trying to come up with a daily cost sheet. What I've done so far
    is develop a tab on the spreadsheet that has all the information, that
    I want to retrieve. Now, what I want to do is develop a "summary
    page" that retrieves information by date. So, what I did was come up
    with a drop down menu where you are allowed to select the date on
    which you want to view the performance of the day.

    My question is how do I make the information change on the "summary
    page", once you select a different date?
     
    , Jan 29, 2008
    #1
    1. Advertisements

  2. kaliman Guest

    It seems to me that a Pivot Table could help you, putting the "Date" field in
    the "Page" section of the layout.

    Give it a try and if you get stuck let us know.

    K.

    "" wrote:

    > I'm trying to come up with a daily cost sheet. What I've done so far
    > is develop a tab on the spreadsheet that has all the information, that
    > I want to retrieve. Now, what I want to do is develop a "summary
    > page" that retrieves information by date. So, what I did was come up
    > with a drop down menu where you are allowed to select the date on
    > which you want to view the performance of the day.
    >
    > My question is how do I make the information change on the "summary
    > page", once you select a different date?
    >
     
    kaliman, Jan 29, 2008
    #2
    1. Advertisements

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.
Similar Threads
  1. chocolatelustbo

    time and cost calculations

    chocolatelustbo, Nov 10, 2003, in forum: Microsoft Excel Discussion
    Replies:
    1
    Views:
    257
    Ron Rosenfeld
    Nov 10, 2003
  2. Neal Reid

    Charting a cost model

    Neal Reid, Feb 21, 2004, in forum: Microsoft Excel Discussion
    Replies:
    2
    Views:
    281
    Neal Reid
    Feb 22, 2004
  3. Pheng

    Cost of shipping calculation

    Pheng, Jul 8, 2004, in forum: Microsoft Excel Discussion
    Replies:
    1
    Views:
    247
    Nick Hodge
    Jul 8, 2004
  4. Frank Kabel

    Cost Per Minute?

    Frank Kabel, Jul 13, 2004, in forum: Microsoft Excel Discussion
    Replies:
    3
    Views:
    448
  5. SRL

    Call cost per minute problem

    SRL, Apr 25, 2006, in forum: Microsoft Excel Discussion
    Replies:
    2
    Views:
    395
  6. Guest

    Multiply hours:minutes by cost/hour to get total cost?

    Guest, May 3, 2006, in forum: Microsoft Excel Discussion
    Replies:
    4
    Views:
    4,455
    Guest
    May 3, 2006
  7. Replies:
    1
    Views:
    396
    R..VENKATARAMAN
    Sep 1, 2006
  8. AA Arens

    Value of sheet A cell = sheet B cell => fill in sheet name

    AA Arens, Nov 25, 2006, in forum: Microsoft Excel Discussion
    Replies:
    4
    Views:
    423
    Dave Peterson
    Nov 26, 2006
Loading...