hi Vanessa,

without more detail, here is a possible solution to a possible
scenario that might get you thinking,

suppose you have two worksheets in two workbooks,

1) normalize the format of the data on the two spreadsheets, ie make
them of the same structure or layout, then

2) if the data is static copy and paste each worksheet into different
worksheets of a third workbook, or hyperlink them if the data is not
static

3) make the each corresponding cell on the third worksheet the
difference of each cell in the first two

------------------------------------------------------------------------
ExcelJockey's profile: http://www.exceljockeys.com/forums/p...iewprofile&u=4
View this thread: http://www.exceljockeys.com/forums/v...c.php?t=304626