Greetings, I would be very grateful if you could give me some idea, you will see I am trying to develop a code that allows me, through a macro, to apply the XLookUp function to compare two tables (TABLE1 AND TABLE1) and enter, according to their ID, the weight and the cost of the products in the second table and after leaving the "TABLE1" clean to be filled again,((๐๐๐๐๐๐ ๐๐๐ ๐๐๐๐ ๐๐ ๐๐ ๐๐๐๐ ๐
๐๐ ๐๐๐๐๐๐๐๐)) I'm starting with Vba and I can't get much further than the Dim and the Set, I'm trying to declare the function with Listobjects.ListColumns. DataBody.Range and the function does not accept the range thanks for what you can contribute...
| | | | ID | PRODUCT | WEIGHT | COST | 1001 | APPLE | 0,2 KG | 2,3$ | 1002 | PEAR | 4,5 KG | 3,1$ | 1003 | PEACH | 5,4 KG | 2,1$ | 1004 | STRAWBERRY | 2,9 KG | 3,4$ | 1005 | CANTAOLUPE | 4,9 KG | 4,1$ | 1006 | MANGO | 2,4 KG | 3,2$ | 1007 | ORANGE | 5,9 KG | 1,4$ | 1008 | BANANA | 8,5 KG | 3,2$ | |
---|
| | | | ID | PRODUCT | WEIGHT | COST | 1001 | APPLE | 0,2 KG | 2,3$ | 1002 | PEAR | | | 1003 | PEACH | | | 1004 | STRAWBERRY | | | |
---|
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |
|