Hello,

I have one sheet ("Data") which is essentially a running list of all sorts of data, including a unique ID number in column A. I'd like code that would paste the ID number(s) of any newly added rows into the next available cell on column A in another sheet ("Tracker").

My process:
  1. Paste/enter data into Data sheet
  2. Add newly added ID number from Data sheet into next available cell on Tracker sheet

Your help would be appreciated...thank you!