PDA

View Full Version : VBA to collect data from Pivot



vio.coman
06-01-2016, 08:29 AM
Hey guys,

I've got two pivot tables (tabs "In" & "Out") from which I am trying to collect the data and centralize it in a third tab ("Overview") - please see attachment
"In" - customers in
"Out" - customers out

The criteria for collecting the data is fairly simple:
a. the code should fistly copy all the data from tab "Out" into tab "Overview" (red)
b. then it should compare if any of the customers contained in "Out" are available also in tab "In". If so, it should pick the correspondent data in columns F & G (tab "Overview" - blue)
c. if that is not the case described in the point above, the remaining customers from tab "In" should be listed in tab "Overview" as illustated in the attachment (tab "Overview" - green)

you're help is highly appreciated, many thanks!

regards