example:

cavalier (prints at top of page
1 b3406 93 buick
2 b3407 82 dodge
3 b3487 99 chevy
4 b4132 87 pontiac
5 b3206 75 chevy

aveo (prints top of secon page)
1 b5555 2003 chevy
2 b8654 04 dodge
3 b8989 05 lexus

i want to delete b3206 75 chevy and have everything below it shift up and
stay inline with the numbers. example delete b3206 75 chevy, now b5555 2003
chevy would be number 5 on page one and b8654 04 dodge would be number 1 on
page 2 and b8989 05 lexus would be number 2 on page 2, and so on.
any help would be appreciated. I beleive i just have the early excell progam