limit rows based on cell value

[kut]

I want to limit the number of rows shown on another sheet based on value in cell "E2"

eg. if E2=12 implies that in sheet2 only 12 rows from top is shown.

 

[YasserKhalil]

Hello
Have a look at this sample workbook. Is that what you want?

 

[kut]

Thanks YasserKhalil, but if value in cell changes its not working.

I want only 12 rows to be shown in sheet2 and no more rows
please

 

[vletm]

kut
Something like this?

 

[kut]

kut
Something like this?

Thanks done.