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
Reply With Quote