+ Reply to Thread
Results 1 to 5 of 5

Choose YTD and Month figures

  1. #1
    Registered User
    Join Date
    03-10-2009
    Location
    Scotland
    MS-Off Ver
    Excel 2007
    Posts
    3

    Choose YTD and Month figures

    I am creating a worbook to generate month end reports. I'd like to pull figures from the various budget sheets into the reporting sheets for the current month and year to date by setting up a variables sheet and I think the "Choose" function but my experimentations have proven me incapable of doing so.

    What I'd like to do is set my month in the variables sheet to the month I want to report in, eg "Feb" and have the budgets pull through automatically. I've a feeling that this is pretty simple and I'd appreciate any help given. I've attached the workbook and highlighted one of the sheets and the columns that I'm trying (and failing miserably) to work with.

    Thanks in advance.
    Attached Files Attached Files
    Last edited by terregles; 03-10-2009 at 11:43 AM.

  2. #2
    Forum Expert NBVC's Avatar
    Join Date
    12-06-2006
    Location
    Mississauga, CANADA
    MS-Off Ver
    2003:2010
    Posts
    34,902

    Re: Choose YTD and Month figures

    This formula in E6 of the P/L sheet copied down will get you the numbers you want:

    Please Login or Register  to view this content.
    apply similarly to other columns/sheets.
    Where there is a will there are many ways.

    If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner

    Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.

  3. #3
    Registered User
    Join Date
    03-10-2009
    Location
    Scotland
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: Choose YTD and Month figures

    Thank you for your help. It was relatively easy to get the Month figures pulling through once you supplied me with the formula, however now I can't work out how to change the formula to pull through the YTD figures. Could you once again point me in the right direction, please?

  4. #4
    Forum Expert NBVC's Avatar
    Join Date
    12-06-2006
    Location
    Mississauga, CANADA
    MS-Off Ver
    2003:2010
    Posts
    34,902

    Re: Choose YTD and Month figures

    In H6:

    Please Login or Register  to view this content.
    copied down

    and in J6, for full year:

    Please Login or Register  to view this content.
    copied down

  5. #5
    Registered User
    Join Date
    03-10-2009
    Location
    Scotland
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: Choose YTD and Month figures

    Thank you. I really appreciate your help and patience. I live in hope that someday I'll have learned enough to tame Excel...

+ 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