I am trying to automate the following but not sure what code to use for it. In sheets("Data") if any value in column A = Employee then copy the corresponding value in column C and paste in sheets("Report") in col C6 and onwards. Many thanks.