Insert new row

hi guys. any help would be much appreciated.
basically i run a report at work where i get loads of clients information.
with some clients they have 2 accounts attached to them, so what i would like to do is have excel/macro automaticvally insert a new line underneath the client if they have a second account. the number of accounts the client has is in, say a6 (1,2,3 accounts) so if client Smith had 2 accounts, i would like a new line inserted underneath smith, before Jones etc.
hope this makes sense. any help would be much appreciated.
cheers

Off the top

Please Login or Register  to view this content.

bob, cheers for the reply.
more info:

this is the kind of thing i have:

Client Number of accounts held

ben 1
adam 1
james 2
dave 1
steve 1
john 1
fred 3
nigel 1
hugo 1
paul 2
tim 1
tom 1


and need it to automatically add the lines as this...

Client Number of accounts held

ben 1
adam 1
james 2

dave 1
steve 1
john 1
fred 3


nigel 1
hugo 1
paul 2

tim 1
tom 1


eg, giving me the space to add in the extra accounts for the clinet. cheers