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()+A1INDIRECT("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 |
+-------------------------------------------------------------------+

--
olasa
------------------------------------------------------------------------
olasa's Profile: http://www.excelforum.com/member.php...o&userid=17760
View this thread: http://www.excelforum.com/showthread...hreadid=378229