jshaner92
02-11-2020, 06:10 AM
We are working on an excel file that has hardware selections and references. These references are used for programming and data entry purposes so they are very very important. There are so many references that we had to separate out the reference tab to its own workbook. We have gotten the workbooks to be able to reference the lists correctly, but as you can see in the attached screenshots, the lists in the entry spreadsheet are not updating to the same location as the same list in the source spreadsheet. When we insert lines in the source spreadsheet to add a new value, the references in the entry spreadsheet do not update at all.
What is the easiest / best way to reference lists from an external workbook and have them updated automatically?
What is the easiest / best way to reference lists from an external workbook and have them updated automatically?