Insert Blank Row In Data

[ExcelRoy]

Morning All,

I am trying to figure out a way to insert a blank row to separate data with different references within column D

The amounts can always change but need all references clumped together for easier viewing

Many thanks for any help!

 

[footoo]

Lots of examples here :
https://www.google.com.hk/search?q=...j69i57j0l3.30077j0j8&sourceid=chrome&ie=UTF-8

 

[ExcelRoy]

Hi footoo,

Many thanks for the links but they appear to be manual option, I was hoping to click a button an automatically insert the desired rows

Could there be a code way around this?

Thanks

 

[footoo]

Hi footoo,

Many thanks for the links but they appear to be manual option, I was hoping to click a button an automatically insert the desired rows

Could there be a code way around this?

Thanks

The link has lots of macros - including a link to a previous MrExcel post that covers what you want.

 

[ExcelRoy]

Git it now, many thanks