Hide rows based on cell value

[mr names]

Hi - I'm fairly new to excel and I'm putting together a 'Quote' sheet.

Basically, I want to make it so that when a sales person enters a number of products in Cell C1, it unhides rows 1 at a time depending on the number.

The rows that I want to unhide are from 19 - 26

For example. if sales person selects 2 in cell C1, then 19 & 20 unhide. If they select 3 in cell C1 then 19,20,21 unhide and so on and so forth. Hope this makes sense!

Cheers!

 

[sycamorm]

Do you have an emample of what i can do and how???