Hello,

I am trying to insert rows between a list, the format of the list is like so:

Asset Number Number of Items Relating to Asset
123456 2
658974 3
125689 10
125468 44
568942 5

What I need to do is insert rows relating to column B. For example I need to insert 2 rows below the first asset number and 5 rows below the last asset number.
Is there a way in which to do this via formula or VBA??

Any help would be much appreciated.

Thanks,

RIK