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.
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.