+ Reply to Thread
Results 1 to 6 of 6

how to create mirror copy of sheets

  1. #1
    Registered User
    Join Date
    02-22-2013
    Location
    India
    MS-Off Ver
    2010
    Posts
    86

    Angry 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

  2. #2
    Registered User
    Join Date
    12-18-2012
    Location
    Burbank, CA
    MS-Off Ver
    Excel 2010
    Posts
    10

    Re: how to create mirror copy of sheets

    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.

  3. #3
    Registered User
    Join Date
    02-22-2013
    Location
    India
    MS-Off Ver
    2010
    Posts
    86

    Re: how to create mirror copy of sheets

    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.

  4. #4
    Registered User
    Join Date
    12-18-2012
    Location
    Burbank, CA
    MS-Off Ver
    Excel 2010
    Posts
    10

    Re: how to create mirror copy of sheets

    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?

  5. #5
    Registered User
    Join Date
    02-22-2013
    Location
    India
    MS-Off Ver
    2010
    Posts
    86

    Re: how to create mirror copy of sheets

    HI ManKorn

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

  6. #6
    Registered User
    Join Date
    02-22-2013
    Location
    India
    MS-Off Ver
    2010
    Posts
    86

    Re: how to create mirror copy of sheets

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

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1