Forum Discussion
Creating a list of products sold together with a selected product
Hi, I have a dataset which includes i.a. orders numbers and names of products. Let's assume it looks like this: Order No. Product 1 A 2 A 2 B 2 C 3 A 3 B 4 A 4 B...
The previous reply could be enhanced by updating the pivot table automatically using VBA. See the attached version.
I have also attached a different, VBA-only solution. It will probably be slow with a large data file.