Hi, Im trying to make a master product part list database for the small company I work for but Im a little rusty with Excel functions and I dont want to use Access.
I want to have a folder for each part number with its own workbook each with:
So I have a matrix of 4x3, lets say the file for this workbook "Part 01.xlsx" is located at \\Company\engineering\Part 01\
I will have a 3rd workbook of a simple list of all part numbers.
I know you can link a matrix from another workbook so something like
Then just drag the cells over
But how can I get the "Part 01" from a list in an array and have it populate from multiple worksheets?
Bookmarks