+ Reply to Thread
Results 1 to 7 of 7

Pivot Table Macro Needed

Hybrid View

  1. 10-20-2014, 10:14 AM #1
    romperstomper
    romperstomper is offline
    Forum Expert romperstomper's Avatar
    Join Date
    08-13-2008
    Location
    England
    MS-Off Ver
    365, varying versions/builds
    Posts
    21,979

    Re: Pivot Table Macro Needed

    Do you mean your headers are in row 2 on the data sheet? Why are you subtracting 2 and not 1 from the last row variable?
    Everyone who confuses correlation and causation ends up dead.
    Reply With QuoteRegister To Reply
  2. 10-20-2014, 10:17 AM #2
    timbo1957
    timbo1957 is offline
    Valued Forum Contributor
    Join Date
    11-15-2007
    Location
    England
    MS-Off Ver
    Office Pro Plus 2021
    Posts
    424

    Re: Pivot Table Macro Needed

    My headers are in row 1 and the total for the sheet is in the very last row which is variable. So I thought I needed to take off 2.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. complex macro needed for pivot table
    By Exceler54 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 06-08-2014, 01:18 PM
  2. Macro Help Needed - Link Pivot Table Filter to Regular Table AutoFilter
    By ycx1129 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-11-2011, 12:54 PM
  3. Macro needed for pivot table
    By PlanetGong in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-13-2009, 05:55 PM
  4. Help needed with Pivot table macro to remove data
    By Nelly in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-09-2006, 09:00 PM
  5. [SOLVED] Macro Needed for Pivot Table
    By douglascfast@hotmail.com in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-12-2005, 12:10 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1