josh_oneill
New Member
- Joined
- Feb 13, 2019
- Messages
- 14
Dear all,
I have searched online for a solution but was unable to find exactly what I need.
I have a spreadsheet to include products in a particular section. I have designated a section of 10 rows for the products I wish to enter. I have a drop down menu/ list with the numbers 0-10. I would like the drop down to hide or un-hide the the same number of rows that is selected.
i.e. I select the number 3, only the first 3 rows should appear. If I then select 8 the first 8 rows should appear and so on. I need this to also hide rows if I had 8 products and now decide I only needed 4 products, only the first 4 rows should be visible.
My drop down is in cell N17 and my rows are 29-38. How do I go about making the cell N17 (Drop down menu) hide and un-hide rows 29-38. FYI row 29 would be product 1 in the drop down, row 30 would be product 2 in the drop down, row 31 would be product 3 in the drop down and so on.
Thanks,
Josh
I have searched online for a solution but was unable to find exactly what I need.
I have a spreadsheet to include products in a particular section. I have designated a section of 10 rows for the products I wish to enter. I have a drop down menu/ list with the numbers 0-10. I would like the drop down to hide or un-hide the the same number of rows that is selected.
i.e. I select the number 3, only the first 3 rows should appear. If I then select 8 the first 8 rows should appear and so on. I need this to also hide rows if I had 8 products and now decide I only needed 4 products, only the first 4 rows should be visible.
My drop down is in cell N17 and my rows are 29-38. How do I go about making the cell N17 (Drop down menu) hide and un-hide rows 29-38. FYI row 29 would be product 1 in the drop down, row 30 would be product 2 in the drop down, row 31 would be product 3 in the drop down and so on.
Thanks,
Josh