I need help to create a macro to copy over from one sheet of data to another sheet of data. It would transfer over data from rows based on the value of the data in specific cell in that row. I don't want the information to be repeated. It will be taken from the first sheet (picture 1) and transferred to the 2nd sheet (picture 2). Based on the final column will determine if it was goes under resignation or term


excel picture.PNG

excel picture 2.PNG