Move new item on list to seperate sheet

J

jlclyde

I am working to put some code together and I am not understanding how
to determine if a newly added name to the bottom of a list is new. I
was thinking of doing a Do until, but that seems like a lot of little
steps to get where I need to go. If I have a list of items in Sheet1
column A and I add a brand new item to the list, I want to move the
item to Sheet2 Column a last row.

Any Ideas?
thanks,
Jay
 
Top