Hello, I'm trying to create a macro that will insert lines from a countif formula.
I have two worksheets, one has tons of date and the range for count if is at colum Q. The second sheet is a template, which I want to insert rows after row 12 (if countif < 8) which where criteria to countif is at cell B6.
On the image you can see in green the criteria for countif, and yellow after this line instert lines if countif less than 8.
I've tried some macros available on web but I couldn't make it work.
Thanks in advance.
I have two worksheets, one has tons of date and the range for count if is at colum Q. The second sheet is a template, which I want to insert rows after row 12 (if countif < 8) which where criteria to countif is at cell B6.
On the image you can see in green the criteria for countif, and yellow after this line instert lines if countif less than 8.
I've tried some macros available on web but I couldn't make it work.
Thanks in advance.