I have been struggling with this problem trying to work it out and can't seem to make it work through the examples I have found.
I have an Excel document which has 2 tabs. The first is a user input template and the second has multiple columns of lookup data. As the user inputs data in the template, I need the columns, 'School', 'Subject' and 'Year Levels' to autocomplete based on the entries in its corresponding column on the Data-Lookup tab. Data input is to be restricted to only the entries in the corresponding list. Is there anyway to do this with code? I have attached an example for reference.
Thanks in advance