MrExcel Publishing
Your One Stop for Excel Tips & Solutions

pullling only non-zero value rows from a table


Posted by kevin on August 27, 2001 8:35 AM

I have a table in excel that contains three columns with numbers and a fourth column that sums the first three columns. I need to pull data from this table into a new table, but i want it to only pull the rows that contain a total greater than zero. for example if I have data in rows 1, 2, 3, 5, and 6, and there is zero in row 4, I want the data to get pulled into a new table where the data from row 1 will get pulled to row 1, row 2 to row 2, row 3 to row 3, (row 4 will not get pulled), row 5 to row 4, and row 6 to row 5. Hope this makes sense. Can anyone help with this?

Thanks,
Kevin


Posted by Dax on August 27, 2001 9:07 AM

You could use VBA to do this in one step or you could use an autofilter. Apply the autofilter and then show just rows where the total is>0. Then highlight the cells and copy. This will only copy visible cells which you can then paste into your other worksheet.

HTH,
Dax.

Posted by kevin on August 27, 2001 9:44 AM

works like a charm - thanks