+ Reply to Thread
Results 1 to 3 of 3

Compare Value between 6 sheets and copy the highest value into different sheet

  1. #1
    Registered User
    Join Date
    11-26-2010
    Location
    Malaysia
    MS-Off Ver
    Excel 2003
    Posts
    9

    Compare Value between 6 sheets and copy the highest value into different sheet

    Hello guys, I have a question here

    I have a data and I have 6 worksheets in one workbook.
    I would like to compare value between the worksheets at the same column..
    for example i would like to compare value of column b row 1 for each worksheets and the maximum value will be copy and pasted into new worksheets..

    I have attached a sample here..
    May u all help me..Thanks a lot..

    Regards..
    Attached Files Attached Files

  2. #2
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    15,602

    Re: Compare Value between 6 sheets and copy the highest value into different sheet

    Rename first and last sheets as START and END
    In 7th sheet in B1 write: =MAX(START:END!B1) and pull down

  3. #3
    Registered User
    Join Date
    11-26-2010
    Location
    Malaysia
    MS-Off Ver
    Excel 2003
    Posts
    9

    Re: Compare Value between 6 sheets and copy the highest value into different sheet

    thanks a lot zbor...
    really appreciate it...:D


    after i know the max value, is there is code so that i will know which sheets the max value is?
    how do i do that?

    can u help me..

    Regards...
    Last edited by djmal; 12-02-2010 at 05:03 AM.

+ 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