+ Reply to Thread
Results 1 to 4 of 4

How to have a Pivot copy a formula along?

  1. #1
    Registered User
    Join Date
    01-25-2019
    Location
    germany
    MS-Off Ver
    2010
    Posts
    2

    How to have a Pivot copy a formula along?

    Hello everyone,

    We use a Pivot to check sequencing errors, e.g. not starting with a 1 or if entry has max sequence of 5, but only 4 entries.
    To check that we have a Pivot and 2 formulas next to it. When we refresh the Pivot the formulas are not dragged along so they have to be copied down everytime.

    Is there any way to tell a Pivot that formula x should always be in column y?

  2. #2
    Valued Forum Contributor
    Join Date
    05-29-2020
    Location
    NH USA
    MS-Off Ver
    365
    Posts
    611

    Re: How to have a Pivot copy a formula along?

    Possibly, you can record a macro of you entering the formula and re-apply the macro after the pivot refresh?

  3. #3
    Registered User
    Join Date
    01-25-2019
    Location
    germany
    MS-Off Ver
    2010
    Posts
    2

    Re: How to have a Pivot copy a formula along?

    It has to be without Macro etc., I meant more like if it's possible to "assign" that in the Pivot itself

  4. #4
    Forum Expert rorya's Avatar
    Join Date
    08-13-2008
    Location
    UK
    MS-Off Ver
    2016 primarily
    Posts
    4,810

    Re: How to have a Pivot copy a formula along?

    A pivot table cannot affect formulas that are adjacent to it without code. It might be possible to do it with the pivot table itself but you haven't supplied enough information to say whether that's an option.
    Rory
    I drink, and I know things

+ 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. Copy from pivot table and paste with formula
    By prabhubox@yahoo.com in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 03-12-2017, 12:57 PM
  2. Copy from pivot table and paste with formula
    By prabhubox@yahoo.com in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-03-2017, 02:28 AM
  3. VBA to copy pivot dates and paste into sheet and apply formula
    By marxism in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-31-2016, 01:40 AM
  4. [SOLVED] VBA to copy a formula down a range based on the size of the pivot table parallel to it
    By The_Snook in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-24-2013, 10:35 AM
  5. [SOLVED] How to copy down formula when references are in a pivot?
    By Bandini in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 11-06-2012, 12:16 PM
  6. Formula to copy pivot table results if match into master sheet
    By monmar in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 08-16-2012, 10:03 PM
  7. Pivot table - Copy Formula Down
    By Aland2929 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-23-2010, 03:33 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