I've been researching for an answer but didn't find one solving my problem.
Context: I'm building a file for people to enter all their team members names in a table. I want the table to be tailored to the number of team members : let's say that they enter in cell A1 the number of members in their team. If they insert the number 5 in A1: the table would be 5 lines. If they insert the number 30, the table would be 30 lines etc. Simplest way is then to pre-create the table and to build a macro to hide lines based on cell A1 value.
So in this context could you please explain how to create this macro?
Imagine the table goes from row 6 to row 100 and column A to H (all team members name would be in column A of the table)
If user enters a value in A1, and if value is 1: rows 7 to 100 would be hidden (leaving only line 6 in the table, for 1 team member), if the value entered in A1 is 2: row 8 to 100 would be hidden (leaving 2 lines), etc and etc.
I guess I would need to create a variable but I'm a bit lost here.
Can someone help?