How do I copy a table w/o certain entries?

[Guest]

I have a table 4x316 that I wish to use as source for a table 4x316. The
resulting array should only contain info on states with a taxable amount.
What is the simplest way to accomplish this?

source table desired result
state taxable amt tax code rate state code
taxable amt rate
LA 25.00 .50 12-12 2% LA
12-12 25.00 2%
MS .00 .00 36-92 4% TX
06-32 14.25 5%
TX 14.25 .71 06-32 5%

 

[Peo Sjoblom]

Apply autofilter, then copy the visible cells (F5, select special and
visible cells only) copy and paste

To filter on taxable amount I assume you could use custom and greater than
0.00 or whatever criteria you are using in the table


--


Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com

 

[Guest]

I was hoping to do it with formulas so it would be 'automatic' instead of
manual.