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.

Share This Page