How do I hide and unhide cell contents?

[cdmterence]

When team number is entered, excel must show or hide the the team
e.g when you enter 5 as the required team number then only 5 teams appear and the rest of the teams are hidden

I have attached excel file that has the layout.

[:) Sixthsense :)]

Do right click on sheet tab and select view code and paste the below code... Return to excel and check...

Please Login or Register  to view this content.

[Winon]

Hello cdmterence,

when you enter 5 as the required team number then only 5 teams appear and the rest of the teams are hidden

Maybe as per the attached sample Workbook then?

Regards

[cdmterence]

Thanks a million the excel sheet works great

[Winon]

Hello cdmterence,

Thank you for the feedback!

You are welcome.

Glad I could help.

If you are satisfied with the solution I had given you, then please mark your Thread as Solved.

You may also Click on the Star to the far left, at the bottom of this Post, to Add Reputation.

Regards.

[Winon]

Hello cdmterence,

Thank you for marking this thread as Solved, and adding to my Reputation.

Regards

[Xx7]

Try this! No VBA necessary...

[cdmterence]

You welcome

[Winon]

Hello Xx7,

Try this! No VBA necessary...

I have also considered that option, still with a Dropdown to select the number of teams.

But then I realised that if there are any other non formulae related data, colors, or any other formatting in any adjacent Cells, it would remain visible. That is why it left me no other option but than going with VBA, to hide non related info.

Regards.