Closed Thread
Results 1 to 2 of 2

multiple pivot tables to a worksheet

  1. #1
    Registered User
    Join Date
    04-25-2005
    Posts
    2

    multiple pivot tables to a worksheet

    I create a Survey report every day


    Question I have a datasheet with 25 question each answer is given 1 out of 5

    (Strongly Agree, Agree, Neither Agree or disagree, Disagree and Strongly disagree)


    I would like a macro to create 25 Pivot tables with the results on a single worksheet


    Is this possible???

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2405 (Windows 11 23H2 64-bit)
    Posts
    81,418

    Re: multiple pivot tables to a worksheet

    Administrative Note:

    Welcome to the forum.

    Unfortunately, this is a duplicate thread, and you are allowed only ONE thread per issue here.

    Please see Forum Rule #5 about thread duplication.

    I am closing this thread, but you may continue here in the original thread: https://www.excelforum.com/excel-cha...worksheet.html
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

Closed Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. multiple pivot tables on a worksheet
    By bootney in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 04-09-2022, 11:45 AM
  2. Create Multiple Pivot Tables in the one Worksheet using vba
    By Buzza20 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-11-2020, 06:35 AM
  3. Updating multiple pivot tables on one worksheet only
    By Simpson67 in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 11-17-2016, 10:40 AM
  4. Creating multiple pivot tables in one worksheet based on different data
    By hwopt in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-08-2014, 10:28 PM
  5. Replies: 0
    Last Post: 03-22-2014, 10:56 AM
  6. Show/Hide multiple Pivot Tables on a single worksheet
    By Reginald888 in forum Excel General
    Replies: 0
    Last Post: 08-25-2009, 02:18 PM
  7. [SOLVED] Multiple Pivot Tables, Same Worksheet, Single Page Field
    By Alan Whitehouse in forum Excel General
    Replies: 2
    Last Post: 06-10-2005, 09:05 AM

Tags for this Thread

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