Forum Discussion
Solved
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.
Patrick, this is exactly what I was looking for & I'm even happier that it doesn't require messing with Macros. Thank you, kindly!
You're welcome!
- Patrick, is there any way to retain the height of the row when making this transfer?
- Unfortunately not with a formula. You'd have to use Auto-Fit row height to adjust the row heights to display the text.