I have a master spreadsheet to collate data from spreadsheets filled in by my colleagues.
Column b is 'Transaction Type' and I want to provide a dropdown list on the input sheets based on a named list in my master called Transactions. This list is subject to change and I don't want to have to update on each individual input spreadsheet.
Data Validation doesn't allow me to link to another workbook. Can anyone suggest a way round this?