Hi all
I was hoping someone can help me with some VBA to achieve what I am looking for.
Basically on Sheet 1 the users enters a list of names in Column A and then dates of employment in Columns B to C. So in the below example Jack was employed from 01/01/1980 until 31/12/1985.
Sheet 1...