EXCEL - save data automatically into sheet 2

[696796]

Hi,

I have this sheet which i am currently working on - what i would like to do is everytime a new bit of data is added to sheet1, it automatically updates sheet2 (which is a datastore). It has to be able to find the next blank cell in the store so data isn't overwritten.

I would prefer not to use a button but am open to suggestions. Are there change events i could put code behind?

Kind Regards,

Alex

 

[SkipVought]

Hi,

If you use the Worksheet_Change event, you could mirror each change quite easily on the other sheet, something like this...

  With Target
    OtherSheet.Cells(.row, .column).value = .value
  End With

Skip,

_{[red]A palindrome gone wrong?[/red]
A man, a plan, a ROOT canal...
PULLEMALL!}