Deepak

One way. First you must duplicate the data on each row, eg.

c.code c.name ??? apr may jun july Total
1010 xxxx 2005-06 10 25 10 25 70
1010 xxxx 2006-07 20 25 5 10 60
1010 xxxx 2007-08 30 25 55 110
1020 xxxx 2005-06 10 25 10 25 70
1020 xxxx 2006-07 20 25 5 10 60
1020 xxxx 2007-08 30 25 55 110

Choose, Data, Filter, AutoFilter. Make the selection on the criteria you
want and paste it into another sheet. If this is OK you can improve it later
with macro.

To automate a filters and filtered List see
www.contextures.com/xlautofilter01.html and you should be able to develop a
fully automated routine.

Regards
Peter
=========================
"deepak bsg" wrote:

hello every body
i'm having a problem with formulas, i'm having
a data with sales volumes for
different years and monthwise sales volumes i.e

c.code c.name apr may jun july tot
1010 xxxx 2005-06 10 25 10 25 70
2006-07 20 25 5 10 60
2007-08 30 25 55


1020 xxxx 2005-06 10 25 10 25 70
2006-07 20 25 5 10 60
2007-08 30 25 55

I want to copy the 2007-08 volumes by criteria
c.code. I cannot copy the c.code in to the all relative
years(rows).Alredy i tried hlookup with if. But i'm not
able to get it can any one assistance plz.

Thanks inadvance