dgt
11-04-2014, 12:57 PM
Hi all
Been struggling with various bits of code that I found online to try and resolve this problem but without success.
In the attached sample worksheet, I want to automatically hide rows prior to the date shown in C5 as they will always be zero. So in this instance I would like to hide all rows highlighted in yellow. I have been trying out code to work on the basis that all rows are hidden before the entry in E138 based upon it matching the figure in E5.
However, when a new customer is inputted in C2 the figures and starting point will change to a different position (date) depending upon the date shown in C5 which could result in the filled range starting anywhere from A9 to A156 which also expands on a weekly basis.
The grey area at the bottom contains various formula but there is always 2 empty rows between the final row of data and these calculations. I use the me.calculate to update the formulas as new input is entered in the top data cells above row 9.
Hopefully this can be resolved quite simply.
TIA ...David
:hi:
Been struggling with various bits of code that I found online to try and resolve this problem but without success.
In the attached sample worksheet, I want to automatically hide rows prior to the date shown in C5 as they will always be zero. So in this instance I would like to hide all rows highlighted in yellow. I have been trying out code to work on the basis that all rows are hidden before the entry in E138 based upon it matching the figure in E5.
However, when a new customer is inputted in C2 the figures and starting point will change to a different position (date) depending upon the date shown in C5 which could result in the filled range starting anywhere from A9 to A156 which also expands on a weekly basis.
The grey area at the bottom contains various formula but there is always 2 empty rows between the final row of data and these calculations. I use the me.calculate to update the formulas as new input is entered in the top data cells above row 9.
Hopefully this can be resolved quite simply.
TIA ...David
:hi: