Results 1 to 17 of 17

compare data from two different sheets in same workbook

Threaded View

akulka58 compare data from two... 12-11-2012, 05:24 PM
akulka58 Re: compare data from two... 12-15-2012, 09:50 AM
Winon Re: compare data from two... 12-15-2012, 10:29 AM
akulka58 Re: compare data from two... 12-24-2012, 01:58 PM
AB33 Re: compare data from two... 12-24-2012, 03:29 PM
akulka58 Re: compare data from two... 12-24-2012, 03:38 PM
AB33 Re: compare data from two... 12-24-2012, 03:46 PM
Winon Re: compare data from two... 12-25-2012, 03:24 AM
AB33 Re: compare data from two... 12-25-2012, 09:59 AM
akulka58 Re: compare data from two... 12-25-2012, 01:34 PM
Winon Re: compare data from two... 12-25-2012, 04:34 PM
AB33 Re: compare data from two... 12-25-2012, 05:00 PM
akulka58 Re: compare data from two... 12-25-2012, 09:47 PM
Winon Re: compare data from two... 12-26-2012, 03:18 AM
AB33 Re: compare data from two... 12-26-2012, 04:47 AM
akulka58 Re: compare data from two... 12-26-2012, 02:11 PM
AB33 Re: compare data from two... 12-26-2012, 03:43 PM
  1. #1
    Forum Contributor
    Join Date
    10-21-2012
    Location
    Ind
    MS-Off Ver
    Excel 2010
    Posts
    110

    Post compare data from two different sheets in same workbook

    hello all,

    i am facing problems. need your help on below problem.

    i do have one workbook. please find attached example workbook. in that workbooks i do have 4 sheets that is fpl,ldn,result matched and result unmatched. i need to compare fpl col c to ldn col d. if cell is matching perfectly then then macro must highlight that row in green color in both sheets. if cell is not matching then macro will highlight that row in red color in both sheets. the another thing is i need to copy matched rows from both sheet and paste in result matched sheet. the same activity i must do with unmatched cell that is those cells which are not matching and we highlighted in red color must paste into result unmatched sheet.

    guys every i received minimum 2000 rows data and its very tedious task to do that. i use excel 2010.

    please help me.....
    Attached Files Attached Files

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