Named ranges
Infor BI Q&A uses Named Ranges as a powerful method of controlling your queries throughout your workbook. Named Cells can now be used to specify a filter within the Q&A Excel Editor. For example, if a worksheet cell contains a Customer Code, you can assign an Excel Name for that Cell, then you need only change that value, which means that all queries that pick up that name will have an amended filter.