Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Mar 2002
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Pivot Tables Many Weeks Data (XL 2000)

    I was wondering if anyonehas figured out how to add say 3 years worth of weekly data to pivots without draging and dropping 3*52 or 156 weeks onto the pivot? It seems like you should be able to hit ctrl and select the pivot columns but that does not work. Has anyone written a macro to do this?

  2. #2
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Pivot Tables Many Weeks Data (XL 2000)

    You mean to say those data are on different sheets?

    I would set up one sheet with all data and base the PT on that, using a dynamic defined name as it's source:

    Name:
    PivotSource
    Refers To:

    =OFFSET(Sheet1!$A$1,0,0,COUNTA(sheet1!$A$A),8)

    (8 being the number of columns with data)
    Now you just copy your new data at the bottom of this sheet and refresh the PT.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

Posting Permissions

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