LUIS FREUND
asked on
Rows to expand to fit data in Excel
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!
C--Users-lfreund-Desktop-RFQ-EE.xlsm
I've attached the workbook for reference. Thanks!
C--Users-lfreund-Desktop-RFQ-EE.xlsm
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks Shums.....works great but is it possible to adapt this when there could be a lot of numbers, for example it could be anywhere from 1000's to 6000's, depending what the user inputs that relates to 1000's of rows of data?
ASKER
Good point Matt...I've never done power query inside Excel...
ASKER
I've reposted the workbook....
C--Users-lfreund-Desktop-RFQ-EE.xlsm
C--Users-lfreund-Desktop-RFQ-EE.xlsm
Hi Luis,
I can change any number to their counts. Your initial request was for just two numbers 1000 & 2000. I can send your revised code tomorrow.
Regards,
Shums
I can change any number to their counts. Your initial request was for just two numbers 1000 & 2000. I can send your revised code tomorrow.
Regards,
Shums
It does that now.
2018-02-18_10-23-28.mp4
2018-02-18_10-23-28.mp4
ASKER
True.....but I have thousands of row of data and the numbers will range from the 1000's to the 6000's depending what the user does.
Are you saying that there might be a 1000 or more of the same RFQ_NO on the QA page? If so what happens when you enter the number in the form?
ASKER
There will be a RFQ numbers against no more than 40 part numbers...but will be a lot of RFQ's numbers
Sorry but I still don't understand the problem you are describing when you say
I have thousands of row of data and the numbers will range from the 1000's to the 6000's depending what the user does.
ASKER
on Thousands of row of data there will be RFQ numbers from 1000 to 6000, for example; 1001, 1008, 2009, 2056, 3004, 4001, 5000, 6022...etc. Depending how the user categorizes a block of part numbers the user will enter the RFQ number associated to those part numbers.
So I would need to enter whatever the RFQ number is from the user to populate the form.
So I would need to enter whatever the RFQ number is from the user to populate the form.
How s that different from what is being done now?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you Shums!!!!
Please check attached...try changing values in M6
C--Users-lfreund-Desktop-RFQ-EE.xlsm