software

I have tables running down a spreadsheet that are 3 columns across like
so:

dd-008 etc are just names of boards.

| dd-008 | acrylic | 0 |
| dc-004 | acrylic | 20 |
| db-012 | merlex | 40 |
| da-006 | acrylic | 0 |

There are breaks between the tables..like this one

| dd-004 | acrylic | 10 |
| dc-002 | merlex | 0 |
| da-010 | merlex | 20 |
| da-016 | acrylic | 5 |

My question is, without deleting the row, is there anyway to delete the
values in the rows with a zero and move all the values below it up?

For example, the two tables would then look like this:

| dc-004 | acrylic | 20 |
| db-012 | merlex | 40 |
| dd-004 | acrylic | 10 |
| da-010 | merlex | 20 |

There are breaks between the tables..like this one

| da-016 | acrylic | 5 |

I have worked hours on this with no luck...any ideas?--
grahamhurlburt
------------------------------------------------------------------------
grahamhurlburt's Profile: www.excelforum.com/member.php...oamp;userid=29878
View this thread: www.excelforum.com/showthread...hreadid=498831deleting is easy, but the breaks? What determines where they go after the
deletions?

--

HTH

RP
(remove nothere from the email address if mailing direct)quot;grahamhurlburtquot;
lt;grahamhurlburt.218bqm_1136578207.8248@excelforu m-nospam.comgt; wrote in
message news:grahamhurlburt.218bqm_1136578207.8248@excelfo rum-nospam.com...
gt;
gt; I have tables running down a spreadsheet that are 3 columns across like
gt; so:
gt;
gt; dd-008 etc are just names of boards.
gt;
gt; | dd-008 | acrylic | 0 |
gt; | dc-004 | acrylic | 20 |
gt; | db-012 | merlex | 40 |
gt; | da-006 | acrylic | 0 |
gt;
gt; There are breaks between the tables..like this one
gt;
gt; | dd-004 | acrylic | 10 |
gt; | dc-002 | merlex | 0 |
gt; | da-010 | merlex | 20 |
gt; | da-016 | acrylic | 5 |
gt;
gt; My question is, without deleting the row, is there anyway to delete the
gt; values in the rows with a zero and move all the values below it up?
gt;
gt; For example, the two tables would then look like this:
gt;
gt; | dc-004 | acrylic | 20 |
gt; | db-012 | merlex | 40 |
gt; | dd-004 | acrylic | 10 |
gt; | da-010 | merlex | 20 |
gt;
gt; There are breaks between the tables..like this one
gt;
gt; | da-016 | acrylic | 5 |
gt;
gt; I have worked hours on this with no luck...any ideas?
gt;
gt;
gt; --
gt; grahamhurlburt
gt; ------------------------------------------------------------------------
gt; grahamhurlburt's Profile:
www.excelforum.com/member.php...oamp;userid=29878
gt; View this thread: www.excelforum.com/showthread...hreadid=498831
gt;
cut and copy them maybe. just paste them over the other row.

quot;grahamhurlburtquot; wrote:

gt;
gt; I have tables running down a spreadsheet that are 3 columns across like
gt; so:
gt;
gt; dd-008 etc are just names of boards.
gt;
gt; | dd-008 | acrylic | 0 |
gt; | dc-004 | acrylic | 20 |
gt; | db-012 | merlex | 40 |
gt; | da-006 | acrylic | 0 |
gt;
gt; There are breaks between the tables..like this one
gt;
gt; | dd-004 | acrylic | 10 |
gt; | dc-002 | merlex | 0 |
gt; | da-010 | merlex | 20 |
gt; | da-016 | acrylic | 5 |
gt;
gt; My question is, without deleting the row, is there anyway to delete the
gt; values in the rows with a zero and move all the values below it up?
gt;
gt; For example, the two tables would then look like this:
gt;
gt; | dc-004 | acrylic | 20 |
gt; | db-012 | merlex | 40 |
gt; | dd-004 | acrylic | 10 |
gt; | da-010 | merlex | 20 |
gt;
gt; There are breaks between the tables..like this one
gt;
gt; | da-016 | acrylic | 5 |
gt;
gt; I have worked hours on this with no luck...any ideas?
gt;
gt;
gt; --
gt; grahamhurlburt
gt; ------------------------------------------------------------------------
gt; grahamhurlburt's Profile: www.excelforum.com/member.php...oamp;userid=29878
gt; View this thread: www.excelforum.com/showthread...hreadid=498831
gt;
gt;