Incremental comparison

[Colin Hayes]

Hi

I have a worksheet with a large number of rows and columns. Over the
month , I make amendments to the content of certain cells , I add rows ,
I delete rows.

Is there a method , or a piece of software which can compare my
worksheet from the beginning of the month with my worksheet at the end
to produce a sheet to show which were the rows that were amended , or
deleted , or added?

Essentially a third sheet , hopefully in the same format and layout ,
that shows all the changed rows made over the month?

Grateful for any help.

Thanks

Drno

[olasa]

This might be a start (see enclosed):

Sheet1:
Column A is numbered cells

Sheet2:
A2: =CHOOSE(1+(B2="Row "&ROW()&" added")*1+(B2="Row "&ROW()&" deleted")*2;A1;A1-1;A1+1)
B2: =CHOOSE(1+(ROW()+A1>INDIRECT("Sheet4!A"&ROW()))*1+(ROW()+A1<INDIRECT("Sheet4!A"&ROW()))*2;"";"Row "&ROW()&" added";"Row "&ROW()&" deleted")

Hope it helped
Ola Sandström