Automatically Add a Blank Row Before all Cells Containing 'Major Line'???

[kdanilko]

Hello All,

I am new to this forum.

Anyway, I was wondering if there was a macro that could be run that would insert a row before all cells that contain a 'Major Line'??? I have over 14,000 lines, and it would save a great deal of time rather than having to manually insert all rows where needed . Keep in mind I am new to using VBA, please explain in detail. Would appreciate any help! See the screen shot below, refer to line 7424 where I have manually inserted the row.

ScreenShot of Workbook.PNG

Thanks!

[Norie]

What is a 'Major Line'?

There are no rows with that text in them.

[kdanilko]

The Major Line refers to a product, each product has a different major line. For example, HH&A (refer to screenshot), another might be GASKET, there are several.