Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel: Compare Two Worksheets
Greetings!!
Is there an easy way to compare 2 worksheets in the same workbook?? I have 2 worksheets labeled as: Sheet1 - master Sheet2 - this sheet has been updated I would like to see what cells were updated in Sheet2. thx..thx.. *** Sent via Developersdex http://www.developersdex.com *** |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel: Compare Two Worksheets
Myrna,
Reply to me privately at deitbe at consumer dot org, and I will send you an addin written by me that will add this sort of functionality to your tools menu. HTH, Bernie MS Excel MVP "Myrna Rodriguez" wrote in message ... Greetings!! Is there an easy way to compare 2 worksheets in the same workbook?? I have 2 worksheets labeled as: Sheet1 - master Sheet2 - this sheet has been updated I would like to see what cells were updated in Sheet2. thx..thx.. *** Sent via Developersdex http://www.developersdex.com *** |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel: Compare Two Worksheets
Myrna, Copy this sub into a standard module and run it. HTH, James
Sub Compare2Shts() Dim cell As Range, x As Long, y As Integer Sheets("Sheet2").Activate Cells.Interior.ColorIndex = xlNone For Each cell In ActiveSheet.UsedRange.Cells x = cell.Row y = cell.Column If Sheets("Sheet1").Cells(x, y) < cell Then cell.Interior.ColorIndex = 3 Next cell End Sub Myrna Rodriguez wrote: Greetings!! Is there an easy way to compare 2 worksheets in the same workbook?? I have 2 worksheets labeled as: Sheet1 - master Sheet2 - this sheet has been updated I would like to see what cells were updated in Sheet2. thx..thx.. *** Sent via Developersdex http://www.developersdex.com *** |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel VBA. Compare 2 worksheets. | Excel Worksheet Functions | |||
Excel: Compare Two Worksheets | Excel Programming | |||
Excel: Compare Two Worksheets | Excel Programming | |||
Can I compare two worksheets using Excel? | Excel Worksheet Functions | |||
Compare 2 similar excel worksheets | Excel Worksheet Functions |