compare information from two spreadsheets or excel sheets
 

Don't know if any one can help, I am trying to find an easy way to compare
data from one spread sheet to another on Excel 2000. Every week I create a
spreadsheet and need to find out if any further items added on it.

example old spreadsheet would be called Andrews 19.04.2010 with 3 sheets 4
columns on each. The new one would be Andrews 26.04.2010 same set up again
but possibley new items on the Andrews 26.04.2010

compare information from two spreadsheets or excel sheets
 

Add a fifth corresponding column on the NEW sheet and insert the following
formula in the first cell:
=SUMPRODUCT((OldSheet!A:A=A1)*(OldSheet!B:B=B1)*(O ldSheet!C:C=C1)*(OldSheet!D:D=D1))

Copy it down.

This will give u the no. of times the an identical entry is occurring in the
OldSheet. The cells with result 0 will be the ones that are new.

--
Thanx & Best Regards,

Faraz!


"EJA" wrote:

Don't know if any one can help, I am trying to find an easy way to compare
data from one spread sheet to another on Excel 2000. Every week I create a
spreadsheet and need to find out if any further items added on it.

example old spreadsheet would be called Andrews 19.04.2010 with 3 sheets 4
columns on each. The new one would be Andrews 26.04.2010 same set up again
but possibley new items on the Andrews 26.04.2010