I have this form called RFQ and in the blue section for example I wanted it to expand automatically if the data does not fit in the blue highlighted area. For example if I type in 1000 in M6 that will populate the blue area just fine since its less than 10 rows but if I type in 2000 in M6 that has 24 rows of data and I wanted the blue section to expand to fit it. Now if I type 1000 again then I wanted it to go back to the normal 10 rows.
I've attached the workbook for reference. Thanks!