Incremental comparison

  • Thread starter Thread starter Colin Hayes
  • Start date Start date
C

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
 
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


+-------------------------------------------------------------------+
|Filename: Book4.zip |
|Download: http://www.excelforum.com/attachment.php?postid=3480 |
+-------------------------------------------------------------------+
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Match and delete rows on two different sheets from reference numbers 4
monthly consolidation in separate worksheet 1
Excel Columns moving up and down on their own in a worksheet. What Goes? 2
Excel formulas - comparing adjacent cells 5
Sort by Colour 2
Deleting rows which contain blank cells 11
complex sort search and replace macro 2
Excel macro code for copying data to a cell reference which is set byvalues in two separate cells in 3

Back
Top