driver_1980
New Member
- Joined
- Nov 14, 2020
- Messages
- 4
- Office Version
- 365
- Platform
- Windows
Hello
Is it possible to link a table with another table in Excel? I have a table (table 1) which contains raw material (item ID, item name) and another table (table 2) that records raw material inventory. I've set up data validation with COUNTIF function to prevent duplicate ID numbers. When I add a new row/record to table 1 with a new material, is it possible to have that new material automatically populate a new row in the raw material inventory table (table 2)? Or just populate one new cell such as the item ID in table 2 and then use VLOOKUP for the rest of the row?
Thank you in advance.
Is it possible to link a table with another table in Excel? I have a table (table 1) which contains raw material (item ID, item name) and another table (table 2) that records raw material inventory. I've set up data validation with COUNTIF function to prevent duplicate ID numbers. When I add a new row/record to table 1 with a new material, is it possible to have that new material automatically populate a new row in the raw material inventory table (table 2)? Or just populate one new cell such as the item ID in table 2 and then use VLOOKUP for the rest of the row?
Thank you in advance.