-
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.
-
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
-
Forum Rules