Want to create 3 queries that have a column filter in them. Rather than set the filter value by using a hard value I would like the filter value to be decided by a cell value in the workbook. So rather than this in my query : = Table.SelectRows(#"Filtered Rows2", each [Region] = "Hospitality and Leisure LC")
I want to have a cell reference instead of 'Hospitality and Leisure LC" . The cell in question will be a drop down cell where the user will select a name of a business type- This will save me creating a further 12 versions of the 3 initial queries (36 queries in total)
