Comparing pivot table and inserting value in cell

E

eurano

New Member
Joined
Sep 13, 2015
Messages
25
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:
http://i.imgur.com/TTbYatI.png?1
http://i.imgur.com/2HHwUjH.png?1

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 "SENT" to the cell in column "X" in the sheet "AKTUALNIE" in row wich contain this mutual value. Both pivot tables are allways filtered in case this will change something.
 

Excel Facts

Does the VLOOKUP table have to be sorted?
No! when you are using an exact match, the VLOOKUP table can be in any order. Best-selling items at the top is actually the best.
You must log in or register to reply here.

Similar threads

Y
  • Question Question
Pivot Table deletes on opening of workbook
Replies
3
Views
199
cooleomter
C
T
  • Question Question
Clear FIlters of Pivot Table after Cell Value Changes
Replies
4
Views
408
Alex Blakenburg
A
W
  • Question Question
Macro/VBA code code for creating new excel file for each pivot table from a column filter
Replies
1
Views
357
Anthony47
A
C
  • Solved
Automatically refresh pivot table filter to remove spaces and blanks
2
Replies
15
Views
439
Alex Blakenburg
A
G
  • Question Question
Edit pivot table cells
Replies
4
Views
366
Cubist
Cubist

Forum statistics

Threads
1,223,248
Messages
6,171,027
Members
452,374
Latest member
keccles

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top