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?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. chocolatelustbo

    time and cost calculations

    chocolatelustbo, Nov 10, 2003, in forum: Microsoft Excel Discussion
    Replies:
    1
    Views:
    205
    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:
    223
    Neal Reid
    Feb 22, 2004
  3. Guest

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

    Guest, May 3, 2006, in forum: Microsoft Excel Discussion
    Replies:
    4
    Views:
    2,437
    Guest
    May 3, 2006
  4. Replies:
    1
    Views:
    197
    R..VENKATARAMAN
    Sep 1, 2006
  5. 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:
    230
    Dave Peterson
    Nov 26, 2006
Loading...

Share This Page