+ Reply to Thread
Results 1 to 2 of 2

Move Pivot Table to align with last row of other column

  1. #1
    Registered User
    Join Date
    01-31-2019
    Location
    Australia
    MS-Off Ver
    2019
    Posts
    2

    Post Move Pivot Table to align with last row of other column

    I'm pretty new to using VBA, so please excuse my lack of knowledge or choice of words to describe my question

    Alright so I have a;

    -Pivot table 1 (A25:B29)
    -Pivot table 2 (A31:B34)
    -A regular table (D1:K50) ~ this table is constantly changing it's height (row count) could be K50 upto K60 sometimes

    Hopefully the above details are clear

    Okay so I would like to move the two pivot tables so that the bottom row of the lower table aligns with the regular table.

    The desired end result would be (IF THE REGULAR TABLE'S BOTTOM ROW IS 50)

    -Pivot table 1 (A41:B45)
    -Pivot table 2 (A47:B50)

    So I would like to know if there's a vba code to allow this to be done, as the regular table will be constantly updating and changing in height.
    Last edited by Lochlan97; 02-28-2020 at 04:15 AM.

  2. #2
    Registered User
    Join Date
    01-31-2019
    Location
    Australia
    MS-Off Ver
    2019
    Posts
    2

    Re: Move Pivot Table to align with last row of other column

    After a bit of trial and error I've fixed my issue

    CODE BELOW FOR ANYONE ELSE THAT FINDS IT USEFUL

    Please Login or Register  to view this content.

+ 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. Replies: 1
    Last Post: 03-25-2018, 04:16 PM
  2. Replies: 0
    Last Post: 08-10-2016, 12:34 PM
  3. [SOLVED] How To Move A Column In A Pivot Table
    By zanshin777 in forum Excel Charting & Pivots
    Replies: 7
    Last Post: 09-13-2015, 10:38 AM
  4. [SOLVED] excel 2010 in pivot table , wants to add row labels, its not align up properly
    By Bitto in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-29-2014, 11:13 AM
  5. [SOLVED] move column total in pivot table to begining
    By flow23 in forum Excel General
    Replies: 0
    Last Post: 12-08-2005, 09:10 AM
  6. Pivot table: order, move to column
    By excelhappy in forum Excel General
    Replies: 0
    Last Post: 05-09-2005, 02:31 PM

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