Inserting a new cell without displacing the informations on the sheet

[Geokakis]

I created an excel programm for updating a data sheet and every updated informations in this data sheet is automatically recorded in another sheet, describing the exact cell the changes was made. But the problem is that if a new cell is inserted into this data sheet it automatically affect the consistence of the other sheet that records the informations changes, causing a disalignment on the excel sheet.

Can you help? and a coprehensive programm code will be very helpfull.

Geo

 

[aMember]

On the sheet you are recording changes, write this formula to the cell

=ADDRESS(ROW(Sheet1!A2),COLUMN(Sheet1!A2))

but replace "A2" with a reference to the cell that changed. In the cell adjacent to this one, write the description of what changed.

HTH