Hi everyone

I want to copy a new entry (Name of candidate) in a list to the same location (e.g. a1,a2... in Sheet1) in another sheet and another list (e.g. a1,a2... in Sheet2. However I need this to be automated (I assume a macro is needed). only the information in column A should be copied as the other entries in the list are different.

I have used a list so that data can be filtered and totaled on the filtered amounts etc.

Have any of you got any ideas?

Thank you

Garry