Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: Pivot table on a active worksheet

  1. #1
    Board Member
    Join Date
    Dec 2015
    Location
    Upstate NY
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Pivot table on a active worksheet

    Can a pivot table be setup to work on an active worksheet? I have a school survey going on and the responses filter to an Excel sheet. I have a table setup to count the number of responses from a given school but as the responses add to the data sheet, can a table increase automatically or do I have to go in and tweak the table accordingly? Hope this is a clear question.

    (By the way, longtime lurker and love the Forum! Happy Holidays all.)

  2. #2
    Board Regular
    Join Date
    Dec 2011
    Posts
    1,218
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Pivot table on a active worksheet


  3. #3
    Board Member
    Join Date
    Dec 2015
    Location
    Upstate NY
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Pivot table on a active worksheet

    I think that's just what I'm looking for. Thanks!

  4. #4
    Board Regular
    Join Date
    Dec 2011
    Posts
    1,218
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Pivot table on a active worksheet

    Thank you for the feedback!
    All the best

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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