View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
OssieMac OssieMac is offline
external usenet poster
 
Posts: 2,510
Default Question about Comparing Data

I have a feeling that you are confusing workbooks and worksheets. Do you mean
2 worksheets or 2 workbooks? Workbooks are the files that are saved.
Worksheets are the individual sheets within a workbook.

Anyway to answer your question. (This will work whether the data is in
separate worksheets within the same workbook or in worksheets in separate
workbooks.)

Because you say the 2 worksheets are identical, you could create a third
worksheet where you insert a formula that subtracts the value of a cell on
one worksheet from the value of the corresponding cell on another worksheet
and drag this formula across the other cells for the size of the worksheets.

Example:- Say you want to compare cell A2 on Sheet1 to cell A2 on Sheet2. In
cell A2 on Sheet3 enter equal sign and then change sheets to Sheet1 and click
cell A2. Then enter minus sign and change to Sheet 2 and click cell A2 then
press Enter to complete the formula. Drag this formula across and then drag
down to a size matching the data on sheets 1 and 2. The differences between
the values will be displayed as positive or negative numbers where there is a
difference or zero where the values are the same.

To make it easy to read, you can then set the options to NOT display zeros
so that only actual differences will be displayed.

--
Regards,

OssieMac


"Adam" wrote:

I have identical worksheets that I create every week. The only thing I change
is the backup data (weekly data). Then I open up last weeks worksheet and
compare the two. Is there an easy way to compare and display the differences
between two identical worksheets? Where it would say this week and last week
we have a difference of 2k? And automatically pull in that information?