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

[Sunny]

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



"Sunny" <Sunny@discussions.microsoft.com> wrote in message
news:02351516-204A-447D-9614-3243BAAD58D1@microsoft.com...
>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%

[Sunny]

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

"Peo Sjoblom" wrote:

> 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
>
>
>
> "Sunny" <Sunny@discussions.microsoft.com> wrote in message
> news:02351516-204A-447D-9614-3243BAAD58D1@microsoft.com...
> >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%
>
>
>