Inserting a blank row

Hello Friends,

Following problem:
I have one excelsheet. That excel sheet contains data. The data is divided into several categories. When I get a new product I have to insert a blank row over the category and insert the data. Now I don't want to manually insert the row over the category but make excel do that. Is there a possibility that I insert a row by just choosing with a drop down list the category and excel automatically inserts the row. I know it doesn't sound much like it would be more efficient then just manually inserting the row, but it is just the first instance to become more efficient.

I hope you understood me well.

Thanks for your help!

Categories.jpg

hi Stefan, can you post a sample workbook with explanations what and where you want to get?