Hide n row sby value, insert n rows instead

[chirilaionut]

Hello,
I need some help to hide rows with blank value in column B, and add same number of rows who was hided instead.
I attached an example: i need to hide 2-7 rows with blanks on column B, and to insert same number of rows bellow row 8, so that the "date" field to be always on row 10.
Thank you very much, have a great day!

[antoka05]

Try with this code:

Please Login or Register  to view this content.

Regards,
Antonio

[chirilaionut]

Thanks Antonio!
That code works incredible well! have a nice day, you are good!
Best regards,
Ionut