Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I'm not even sure if this is possible anymore!
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: http://www.excelforum.com/member.php...o&userid=29878 View this thread: http://www.excelforum.com/showthread...hreadid=498831 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I'm not even sure if this is possible anymore!
deleting is easy, but the breaks? What determines where they go after the
deletions? -- HTH RP (remove nothere from the email address if mailing direct) "grahamhurlburt" <grahamhurlburt.218bqm_1136578207.8248@excelforu m-nospam.com wrote in message news:grahamhurlburt.218bqm_1136578207.8248@excelfo rum-nospam.com... 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: http://www.excelforum.com/member.php...o&userid=29878 View this thread: http://www.excelforum.com/showthread...hreadid=498831 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I'm not even sure if this is possible anymore!
cut and copy them maybe. just paste them over the other row.
"grahamhurlburt" wrote: 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: http://www.excelforum.com/member.php...o&userid=29878 View this thread: http://www.excelforum.com/showthread...hreadid=498831 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
formulas don't work anymore | Excel Discussion (Misc queries) | |||
unselecting not working anymore? | Excel Discussion (Misc queries) | |||
Chart does not Auto-update anymore .Why? | Excel Discussion (Misc queries) | |||
dont need anymore these information | Excel Discussion (Misc queries) | |||
My cell color won't print anymore. | Excel Worksheet Functions |