Hi,
I don't know if this is possible but I have a debtors list made from imported data and there are four columns (M-P) that contain data pertaining to a specific delivery round as each customer could have at least one up to a maximum of four. I need to be able to filter on these columns but for one specific text string which could appear in any of the columns. I know this can be done with an advanced filter but this workbook will be used by many not particularly familiar with Excel and ideally I would like to be able to just give the user a blank cell to enter a text string into and then press a macro assigned button which will automatically filter all rows that contain that string in any of the columns M-P. Is this possible?
Thank you
I don't know if this is possible but I have a debtors list made from imported data and there are four columns (M-P) that contain data pertaining to a specific delivery round as each customer could have at least one up to a maximum of four. I need to be able to filter on these columns but for one specific text string which could appear in any of the columns. I know this can be done with an advanced filter but this workbook will be used by many not particularly familiar with Excel and ideally I would like to be able to just give the user a blank cell to enter a text string into and then press a macro assigned button which will automatically filter all rows that contain that string in any of the columns M-P. Is this possible?
Thank you