Hi,
I'm afraid auto filter isn't an option for what I want to do. What I
want is for excel to pull the data off into a seperate table which then
populates a graph. I've got to do 50 odd of these tables and ideally want to
just paste the info in and then have excel do the rest via formulas. Was
planning to use vlookups to retrive the rest of the data from the table but
need to have the row headings first to do it. Sorry should of said that in
the original post. Any ideas?

Thanks for your help

"Gary''s Student" wrote:

Excel has a powerful feature called AutoFilter that does what you want.

http://www.contextures.com/xlautofilter01.html

Once it is set up, click on the pull-down and pick Custom not equal to 0
for any given month
--
Gary''s Student - gsnu200822


"Dom" wrote:

Hi,
I have a table of data that runs over several months in columns B to D
and I have different types of fruit in rows 2 to 4 e.g apples, pears and so
on. Under each month would be the number of that fruit sold that month:-

Jan Feb Mar
Apples 0 2 3
Pears 5 0 5
Oranges 7 0 6

What I need excel to do is just return the types of fruit where the value is
greater than 0 in a particular month. So if I wanted to know what fruit sold
in Jan it would return:-

Pears
Oranges

The table of data i actually have has 51 "types of fruit" and 28 "months"
but i only need excel to look at one "month" at a time. Hopes this makes
sense and any help you can provide is much appreciated as i've hit a wall
with this.

Thanks