Results 1 to 2 of 2

Thread: Rolling UP Table and Values

  1. #1

    Question Rolling UP Table and Values



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi Everyone, I want help to start this little job

    I need roll up one table and it's values, The Ideal will be automatically change if we are on a new month... and that its no problem with the months

    In the A1 Cell I put
    Code:
    =TODAY()
    on the B1
    Code:
    =DATE(YEAR(A1), MONTH(A1)+1, DAY(A1))
    C1, and so on.
    But i need ideas for roll up also the information below the months.

    Product JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC
    A 1 2 3 4 5 6 7 8 9 10 11 12
    B 1 2 3 4 5 6 7 8 9 10 11 12

  2. #2
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Location
    Mississauga, Canada
    Posts
    1,489
    Articles
    0
    Excel Version
    Excel 2016


Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •