how to create mirror copy of sheets

actually, i want to make a mirror copy of worksheet so that i can use filter option more than one names for the same column and for same sheet. plz anybody can help me out......... if u have something and comfortable to share here then plz help.... or email me amarjeet.it@hotmail.com

Are you trying to copy and paste a sheet, but it's not complying. Can you describe your problem in a little more detail, I think I've been through the same issue.

firstly thanx to you...

my problem is i want make a summery sheet which show calculations of different-different things. but when i made change in items then it recalculates in summery sheet also. n more details is like.....

1 column A column B column C
2 apple banana mango
3 apple banana banana
4 banana mango banana
5 banana mango mango
6 mango banana mango


Now i want to use filter that show banana only in a sheet, again one filter for apple in different sheet, once again one filter for mango in one different sheet. ok if i make change in root sheet( if i replace from apple to banana in A3). it show and increase in the sheet having banana.

Do you want these filters just to count the instances of each cell type?

For example, on one page you have a counter for each time a cell="banana". Every time you change this on the master list, the number changes on the summary list.

This be as easy as using

=COUNTIF(MASTER!$A$1:$C$6,"banana")

Where MASTER is your primary sheet name, A1:C6 is the range of cells on your primary sheet, and "banana" is the term you want found.

Does that help? What else would you like this summary sheet to do?

HI ManKorn

Thank a lot for ur help.......

hi sir i have one problem what i am going to share wid u if u feel comfortable then let me kw that.....