Hi all,
I have been searching for a macro which helps to do the following:
I have a financial statement containing 100 rows, where users can fill in invoice numbers and corresponding amounts of dollars. It's a simple sheet, containing a few headers and a lot of rows.
Now, to keep the sheet neat, I would like to have an option if a user gives in the total number of invoices (e.g. in cell A1), for example 26, that the macro hides all rows after 26 until 100. Is this possible? I have been searching the web for quite a few hours but have not succeeded yet.
Thanks in advance,
Rob
I have been searching for a macro which helps to do the following:
I have a financial statement containing 100 rows, where users can fill in invoice numbers and corresponding amounts of dollars. It's a simple sheet, containing a few headers and a lot of rows.
Now, to keep the sheet neat, I would like to have an option if a user gives in the total number of invoices (e.g. in cell A1), for example 26, that the macro hides all rows after 26 until 100. Is this possible? I have been searching the web for quite a few hours but have not succeeded yet.
Thanks in advance,
Rob