C
chrisnsmith
I posed my problem earlier and Dave Peterson gave me the solution. However
what I said I needed was incorrect. I have only shown 11 rows of what is
actually 50 rows per section (columns A,B & C---columns G,H & I). This
worksheet is set up
this way for printing purposes only. Columns G,H &I should be considered as
extentions of columns A,B & C. What I want to do is, for each row in either
section
that has a value of < 1, I want to clear the contents of that row and move
the other rows up to fill the empty row. This means that every row must
shift upwards from
row 50 of columns G,H & I, putting the contents of the top rows of columns
G,H & I
at the bottom of columns A,B & C and the blank rows at the bottom of columns
G,H & I.
I would also like to sort the entries by oldest date first.
Help.
A B C G H
I
Account Date Amount Account Date Amount
14 cd 2/13/2009 4 bf 2/13/2009 6
15 wf 2/13/2009 3 af 2/13/2009 2
16 we 2/13/2009 56 gf 2/13/2009 34
17 qe 2/13/2009 23 bg 2/13/2009 16
18 rt 2/13/2009 0 fg 2/13/2009 0
19 yu 2/13/2009 23 yk 2/13/2009 45
20 ty 2/13/2009 8 lu 2/13/2009 2
21 ui 2/13/2009 9 tq 2/13/2009 8
22 op 2/13/2009 0 de 2/13/2009 0
23 th 2/13/2009 34 wc 2/13/2009 11
24 bn 2/13/2009 2 bz 2/13/2009 98
25 cv 2/13/2009 1 hm 2/13/2009 1
what I said I needed was incorrect. I have only shown 11 rows of what is
actually 50 rows per section (columns A,B & C---columns G,H & I). This
worksheet is set up
this way for printing purposes only. Columns G,H &I should be considered as
extentions of columns A,B & C. What I want to do is, for each row in either
section
that has a value of < 1, I want to clear the contents of that row and move
the other rows up to fill the empty row. This means that every row must
shift upwards from
row 50 of columns G,H & I, putting the contents of the top rows of columns
G,H & I
at the bottom of columns A,B & C and the blank rows at the bottom of columns
G,H & I.
I would also like to sort the entries by oldest date first.
Help.
A B C G H
I
Account Date Amount Account Date Amount
14 cd 2/13/2009 4 bf 2/13/2009 6
15 wf 2/13/2009 3 af 2/13/2009 2
16 we 2/13/2009 56 gf 2/13/2009 34
17 qe 2/13/2009 23 bg 2/13/2009 16
18 rt 2/13/2009 0 fg 2/13/2009 0
19 yu 2/13/2009 23 yk 2/13/2009 45
20 ty 2/13/2009 8 lu 2/13/2009 2
21 ui 2/13/2009 9 tq 2/13/2009 8
22 op 2/13/2009 0 de 2/13/2009 0
23 th 2/13/2009 34 wc 2/13/2009 11
24 bn 2/13/2009 2 bz 2/13/2009 98
25 cv 2/13/2009 1 hm 2/13/2009 1