Link to home
Start Free TrialLog in
Avatar of LUIS FREUND
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
Avatar of Shums Faruk
Shums Faruk
Flag of India image

Hi Luis,

Please check attached...try changing values in M6
C--Users-lfreund-Desktop-RFQ-EE.xlsm
SOLUTION
Avatar of Matt Nicholas
Matt Nicholas
Flag of Australia image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of LUIS FREUND
LUIS FREUND

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?
Good point Matt...I've never done power query inside Excel...
I've reposted the workbook....
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
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?
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.
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.
How s that different from what is being done now?
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Thank you Shums!!!!