Inserting Rows Via VBA / Formula

[slickrik000]

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

[DonkeyOte]

Numerous methods - one might be:

Please Login or Register  to view this content.

Note: I've not added rows to the last Asset number - given we assume this is the last asset and thus rows below are blank... is this not the case ?

[slickrik000]

Thats correct.

I'll give this a go.

Thanks,

RIKIN