+ Reply to Thread
Results 1 to 2 of 2

Pivot Table Creation

  1. #1
    Registered User
    Join Date
    07-30-2010
    Location
    Warrington, England
    MS-Off Ver
    Excel 2010
    Posts
    71

    Question Pivot Table Creation

    Hi, I'm trying to create a pivot table but without success. It's a very simple pivot which should group on a field called NAME and then sum the values. I first tried to record a macro and then use that code but that didnt work so I've "assembled" some code that almost works but not quite. Here's the code

    Please Login or Register  to view this content.
    If I take out the last line of code the pivot table creates but without a data field. When I put the last line in I get a syntax error which, for the life of me, I can't figure out....very frustrating... I'd appreciate any help...even if it means going back to scratch

    Many thanks

  2. #2
    Forum Guru JosephP's Avatar
    Join Date
    03-27-2012
    Location
    Ut
    MS-Off Ver
    2003/10
    Posts
    7,328

    Re: Pivot Table Creation

    remove the parentheses

    Please Login or Register  to view this content.
    Josie

    if at first you don't succeed try doing it the way your wife told you to

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Pivot Table creation with Macro
    By elevisse in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-25-2012, 02:19 AM
  2. Macro for Pivot Table Creation
    By greenmonke in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-12-2010, 10:05 PM
  3. Pivot table creation
    By zfranks in forum Excel General
    Replies: 1
    Last Post: 03-15-2007, 02:27 PM
  4. [SOLVED] Pivot Table Creation
    By Rob in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-26-2006, 09:10 AM
  5. [SOLVED] Pivot table creation error VBA XLS
    By Willow in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 03-10-2005, 03:06 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