Consulting

Results 1 to 2 of 2

Thread: Sleeper: Comparing pivot table and adding value to cell

  1. #1
    VBAX Newbie
    Joined
    Mar 2016
    Posts
    4
    Location

    Sleeper: Comparing pivot table and adding value to cell

    Hi!
    I have 2 pivot tables called:
    in sheet "AKTUALNIE" the name of the pivot = "Tabela przestawna4"
    in sheet "Arkusz1" the name of the pivot = "Tabela przestawna2"

    screens:
    Bez tytułu1.jpgBez tytułu22.jpg

    What i want to achieve is to make macro wich whenever the pivot "Tabela przestawna2" in column "N" contain value same as pivot "Tabela przestawna4" in column "D" macro will add value "y" to the cell in column "X" in the sheet "AKTUALNIE" in row wich contain this mutual value.
    Last edited by eurano; 04-22-2016 at 12:44 AM.

  2. #2
    Knowledge Base Approver VBAX Wizard
    Joined
    Apr 2012
    Posts
    5,645
    I'm not charmed by pictures, I prefer a sample file.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •