Hello World!,

I have a spread sheet that has a button activated macro. The macro works fine but I now want to add a
part to it but am not sure how.

My spreadsheet has a section of 25 rows containing names and details of staff.
If the week starts with 10 staff then 15 rows are hidden leaving only the rows
containing data visible (10 staff). This is fine but sometimes we get a new member
of staff join us mid week. I want my "new staff" macro to open just one row in order
for whoever is using the spreadsheet to be able to enter data into the newly revealed
row. I just want the macro to reveal the next row only not all remaining rows.

Example
is if have 10 rows at the start of the week on Monday and on Wednesday another member
of staff joins our team we will have 11 staff. A button will be pressed by the user triggering a macro
that reveals just 1 row (not all remaining hidden rows). I hope this makes sense!

Thank you in advance for any help

Margate