filtered lists

Hi, I have a large workbook with certain groups of cells (defined by filters) and want to apply different conditional formats based on those ranges. For example: A: B: Region 1 10/02 Region 3 12/04 Region 2 15/03 Region 1 11/02 Region 2 12/03 Region...

I maintain an add-in with handy macros that we use at work. I would like to add one for copy and pasting filtered lists on the same sheet, e.g. a filtered list in a2:c9 should be copied to g2:i9. Only visible cells should be copied. I know this can be accomplished by: 1: selecting the ‘paste-to’...

Hi everyone, I'm trying to create a series of dependant drop down selections (using data validation). I can get a single drop down working by creating a single-column table of the values, then referencing the table[#data] in a namedRange, which is then referenced in the data validation (list)...

I suspect there is already a question and answer to this issue however...Many Times, you want to use a Drop-Down List Box to provide a Selection List but you don't want to scroll through 8000 Items. What would be the best method of either Filtering or AutoCompleting the drop-down list based on...

I have a master data sheet with 200K+ lines. Every month 30k- 50k lines are added to it. In my pivots that are sourced from this data, I have a customer list where I have filtered out some customers who I do not want to be included in my pivots. Because of this, whenever new customers are added...