When comparing two different worksheets depending on the data depends on
how you would do the comparison

1) The simple Case - the two worksheets always have the save number of
rows and you are comparing the data in the same row on each sheet. Here
you can us conditional formating to compare the two sheets. Use a
formula like this

Sheet1!Q1 : put formula =Sheet2!Q1
Sheet2!Q1 : put formula =Sheet1!Q1


2) If your data has different number of rows or the data is in a
different order then you need a unique ID number so you can compare the
two sheets.. Again you can use conditional formating but us a vlookup
for comparison

Assume a Unique ID is in column A.Vlookup will return NA is the ID
isn't found
Sheet1!Q1 : put formula =NOT(ISNA(VLOOKUP(A1,Sheet2!A1:Q10,17)))
Sheet2!Q1 : put formula =NOT(ISNA(VLOOKUP(A1,Sheet1!A1:Q10,17)))

If you want to compare values
Sheet1!Q1 : put formula =Q1=VLOOKUP(A1,Sheet2!A1:Q10,17)))
Sheet2!Q1 : put formula =Q1=VLOOKUP(A1,Sheet1!A1:Q10,17)))


3) If you have different number of rows and don't have an ID column
then you are out of luck.


--
joel
------------------------------------------------------------------------
joel's Profile: http://www.thecodecage.com/forumz/member.php?userid=229
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=151080

Microsoft Office Help