Hi
I have 3 columns of data - Locations, Packages and Suppliers.
In the small sample below (Table 1), Locations 1 - 10 are listed in column A from cells A2:A11, respectively.
Packages 1 - 5 are listed in cells B2:B6, respectively.
And Suppliers 1 - 12 are listed in cells C2:C13, respectively.
I'd like to use VBA to ensure that for EACH Location AND Supplier, the list of packages is displayed (please see tables 2 and 3 below), as examples.
However, I'd like all the results to be in just three columns - a column for Locations, a column for Packages and a column for Suppliers.
Does anyone know how to do this with VBA, please?
TIA
Table 1
Tables 2 and 3
I have 3 columns of data - Locations, Packages and Suppliers.
In the small sample below (Table 1), Locations 1 - 10 are listed in column A from cells A2:A11, respectively.
Packages 1 - 5 are listed in cells B2:B6, respectively.
And Suppliers 1 - 12 are listed in cells C2:C13, respectively.
I'd like to use VBA to ensure that for EACH Location AND Supplier, the list of packages is displayed (please see tables 2 and 3 below), as examples.
However, I'd like all the results to be in just three columns - a column for Locations, a column for Packages and a column for Suppliers.
Does anyone know how to do this with VBA, please?
TIA
Table 1
| Location | Package | Supplier |
| Location 1 | Package 1 | Supplier 1 |
| Location 2 | Package 2 | Supplier 2 |
| Location 3 | Package 3 | Supplier 3 |
| Location 4 | Package 4 | Supplier 4 |
| Location 5 | Package 5 | Supplier 5 |
| Location 6 | Supplier 6 | |
| Location 7 | Supplier 7 | |
| Location 8 | Supplier 8 | |
| Location 9 | Supplier 9 | |
| Location 10 | Supplier 10 | |
| Supplier 11 | ||
| Supplier 12 |
Tables 2 and 3
| Table 2 | Table 3 | |||||
| Location | Package | Supplier | Location | Package | Supplier | |
| Location 1 | Package 1 | Supplier 1 | Location 1 | Package 1 | Supplier 2 | |
| Location 1 | Package 2 | Supplier 1 | Location 1 | Package 2 | Supplier 2 | |
| Location 1 | Package 3 | Supplier 1 | Location 1 | Package 3 | Supplier 2 | |
| Location 1 | Package 4 | Supplier 1 | Location 1 | Package 4 | Supplier 2 | |
| Location 1 | Package 5 | Supplier 1 | Location 1 | Package 5 | Supplier 2 | |
| Location 2 | Package 1 | Supplier 1 | Location 2 | Package 1 | Supplier 2 | |
| Location 2 | Package 2 | Supplier 1 | Location 2 | Package 2 | Supplier 2 | |
| Location 2 | Package 3 | Supplier 1 | Location 2 | Package 3 | Supplier 2 | |
| Location 2 | Package 4 | Supplier 1 | Location 2 | Package 4 | Supplier 2 | |
| Location 2 | Package 5 | Supplier 1 | Location 2 | Package 5 | Supplier 2 | |
| Location 3 | Package 1 | Supplier 1 | Location 3 | Package 1 | Supplier 2 | |
| Location 3 | Package 2 | Supplier 1 | Location 3 | Package 2 | Supplier 2 | |
| Location 3 | Package 3 | Supplier 1 | Location 3 | Package 3 | Supplier 2 | |
| Location 3 | Package 4 | Supplier 1 | Location 3 | Package 4 | Supplier 2 | |
| Location 3 | Package 5 | Supplier 1 | Location 3 | Package 5 | Supplier 2 | |
| Location 4 | Package 1 | Supplier 1 | Location 4 | Package 1 | Supplier 2 | |
| Location 4 | Package 2 | Supplier 1 | Location 4 | Package 2 | Supplier 2 | |
| Location 4 | Package 3 | Supplier 1 | Location 4 | Package 3 | Supplier 2 | |
| Location 4 | Package 4 | Supplier 1 | Location 4 | Package 4 | Supplier 2 | |
| Location 4 | Package 5 | Supplier 1 | Location 4 | Package 5 | Supplier 2 | |
| Location 5 | Package 1 | Supplier 1 | Location 5 | Package 1 | Supplier 2 | |
| Location 5 | Package 2 | Supplier 1 | Location 5 | Package 2 | Supplier 2 | |
| Location 5 | Package 3 | Supplier 1 | Location 5 | Package 3 | Supplier 2 | |
| Location 5 | Package 4 | Supplier 1 | Location 5 | Package 4 | Supplier 2 | |
| Location 5 | Package 5 | Supplier 1 | Location 5 | Package 5 | Supplier 2 | |
| Location 6 | Package 1 | Supplier 1 | Location 6 | Package 1 | Supplier 2 | |
| Location 6 | Package 2 | Supplier 1 | Location 6 | Package 2 | Supplier 2 | |
| Location 6 | Package 3 | Supplier 1 | Location 6 | Package 3 | Supplier 2 | |
| Location 6 | Package 4 | Supplier 1 | Location 6 | Package 4 | Supplier 2 | |
| Location 6 | Package 5 | Supplier 1 | Location 6 | Package 5 | Supplier 2 | |
| Location 7 | Package 1 | Supplier 1 | Location 7 | Package 1 | Supplier 2 | |
| Location 7 | Package 2 | Supplier 1 | Location 7 | Package 2 | Supplier 2 | |
| Location 7 | Package 3 | Supplier 1 | Location 7 | Package 3 | Supplier 2 | |
| Location 7 | Package 4 | Supplier 1 | Location 7 | Package 4 | Supplier 2 | |
| Location 7 | Package 5 | Supplier 1 | Location 7 | Package 5 | Supplier 2 | |
| Location 8 | Package 1 | Supplier 1 | Location 8 | Package 1 | Supplier 2 | |
| Location 8 | Package 2 | Supplier 1 | Location 8 | Package 2 | Supplier 2 | |
| Location 8 | Package 3 | Supplier 1 | Location 8 | Package 3 | Supplier 2 | |
| Location 8 | Package 4 | Supplier 1 | Location 8 | Package 4 | Supplier 2 | |
| Location 8 | Package 5 | Supplier 1 | Location 8 | Package 5 | Supplier 2 | |
| Location 9 | Package 1 | Supplier 1 | Location 9 | Package 1 | Supplier 2 | |
| Location 9 | Package 2 | Supplier 1 | Location 9 | Package 2 | Supplier 2 | |
| Location 9 | Package 3 | Supplier 1 | Location 9 | Package 3 | Supplier 2 | |
| Location 9 | Package 4 | Supplier 1 | Location 9 | Package 4 | Supplier 2 | |
| Location 9 | Package 5 | Supplier 1 | Location 9 | Package 5 | Supplier 2 | |
| Location 10 | Package 1 | Supplier 1 | Location 10 | Package 1 | Supplier 2 | |
| Location 10 | Package 2 | Supplier 1 | Location 10 | Package 2 | Supplier 2 | |
| Location 10 | Package 3 | Supplier 1 | Location 10 | Package 3 | Supplier 2 | |
| Location 10 | Package 4 | Supplier 1 | Location 10 | Package 4 | Supplier 2 | |
| Location 10 | Package 5 | Supplier 1 | Location 10 | Package 5 | Supplier 2 | |
