missinglina
New Member
- Joined
- Jul 8, 2016
- Messages
- 3
Hi. I have one master table that has all inventory items and their vendor. Then I have many tables which represent specific orders that list varying numbers of items but these tables have no vendor listed and their item name varies from the master list . They have the item's ID number in common. I am creating a relationship between the orders and the master list of items to obtain vendor name, as well as to extract the item name from the master list. The problem I have is that it is very tedious to do it over and over again. All order tables have the exact same structure. Is there a way to tell Power Pivot that the relationship between all of them and the master list is exactly the same? Thanks for any suggestions! I have tried finding the answer but I must be asking it wrong or perhaps applying the wrong tool to begin with within Excel? (2016 version although 2010 can also be utilized)