Forum Discussion
Sorting a Master Spreadsheet into worksheets if cell in sortable column contains (value)
Hello, I am new to working with VBA/Macros generally, and working in Excel 2204 I am looking to create a Master Spreadsheet that automatically will populate existing AND newly entered data into works...
I've revised the sample so exact matching is not required.
Hi Patrick, and thank you for your response. This is very helpful for cases where Column A has a limited number of unique values. Unfortunately, my data set has extra information in addition to the filter, within the same cell, as represented by the digits 1-9 in Column A above. I am hoping to find a way that this automatic population would happen if Column A "contains" value X, rather than "matches" value X. Is there an edit I can make to the filter, or would this require macros?
I've revised the sample so exact matching is not required.
- Patrick, this is exactly what I was looking for & I'm even happier that it doesn't require messing with Macros. Thank you, kindly!
