Hiding and unhiding rows based on a CountA value

Hello

I'm trying to create a macro that hides and unhides certain rows depending on a changing number.

For example, if the countA value is 1, I want rows 1-50 to be shown on another worksheet
If the countA value is 2, I want rows 1-100 to be shown on the other worksheet
If the countA value is 3, I want rows 1-150 to be shown on the other worksheet
and so on

Does anyone know a way I can do this? Thank you

Try the following..
I am sure that will definitely help...

Sub WorkSheet1()
select case Range("A1").value
case 1
Rows("1:50").copy Sheets(2).Range("A1")
Case 2
Rows("1:100").copy Sheets(2).Range("A1")
Case 3
Rows("1:150").copy Sheets(2).Range("A1")
end select
msgbox "Complete!"
End sub

Don't forget to click *

Hello

Sorry I am very new to VBA, should I put this into the worksheet code or create a new macro? Also the worksheet that I am trying to do this in is called Client Reports. The number that it is referencing is in box A1 on the same client reports worksheet. So I want it to automatically show and unshow the rows based on whatever number is in box A1

Thank you SO much for your help!