I want some scattered rows of data that are uniquely identified by a number
(example 3), in a cell in their row. Using an IF function, I want to move
the data to another page, then have it all move up to fill the first open
row. Is this possible. I know how to get the IF part done. But not the
close up the spaces part. For example

Journal entry page
date vendor item amount code

11/30 progress elec 75 .00 3
12/1 taylors supplies 32.90 2
12/29 progress elec 44.00 3


Progress account page (this is how it brings it now, with a space)

Date Item Amt
11/30 elec 75.00
I want to eliminate this space and have the data move up automatically.
12/29 elec 44.00

Is this possible?