dbmathis
Well-known Member
- Joined
- Sep 22, 2002
- Messages
- 1,064
Hi all,
I have the following senario.
Due to the limitations of space on this forum I am only showing K11:M31 but my actual sheet has an area of K11:M41.
Does anyone know how to do the following with VBA? Basically move all blank lines to the bottom of the K11:M41 and move all rows that contain data to the top of the area?
The location of the rows of data within the area of K11:K41 varies from day to day depending on what's deleted, which is what creates these blank lines between data.
For example the end result would be:
Thanks.
I have the following senario.
Transaction Register Starting Dec-16-2005 Draft.xls | ||||||
---|---|---|---|---|---|---|
K | L | M | N | |||
10 | Desciprion | Amount | ||||
11 | #121 Tags | $177.64 | 0 | |||
12 | #123 Truck | $279.89 | 0 | |||
13 | #122 Emmy's Car | $280.00 | 0 | |||
14 | 0 | |||||
15 | 0 | |||||
16 | Burger King | $6.90 | 0 | |||
17 | 0 | |||||
18 | 0 | |||||
19 | 0 | |||||
20 | 0 | |||||
21 | 0 | |||||
22 | 0 | |||||
23 | 0 | |||||
24 | St.Albert | $5.00 | 0 | |||
25 | HEB | $49.06 | 0 | |||
26 | 0 | |||||
27 | 0 | |||||
28 | 0 | |||||
29 | 0 | |||||
30 | 0 | |||||
31 | 0 | |||||
Transaction Register |
Due to the limitations of space on this forum I am only showing K11:M31 but my actual sheet has an area of K11:M41.
Does anyone know how to do the following with VBA? Basically move all blank lines to the bottom of the K11:M41 and move all rows that contain data to the top of the area?
The location of the rows of data within the area of K11:K41 varies from day to day depending on what's deleted, which is what creates these blank lines between data.
For example the end result would be:
Transaction Register Starting Dec-16-2005 Draft.xls | ||||||
---|---|---|---|---|---|---|
K | L | M | N | |||
10 | Desciprion | Amount | ||||
11 | #121 Tags | $177.64 | 0 | |||
12 | #123 Truck | $279.89 | 0 | |||
13 | #122 Emmy's Car | $280.00 | 0 | |||
14 | Burger King | $6.90 | 0 | |||
15 | St.Albert | $5.00 | 0 | |||
16 | HEB | $49.06 | 0 | |||
17 | 0 | |||||
18 | 0 | |||||
Transaction Register |
Thanks.