|I don't have any experience in macros and I would like a code which would automatically copy entire row of data to a seperate worksheet if the "date" column contains a specific code|
Column A B C
Name Ref No. Date
smith 123 2011
baker 465 2016
If cell C contains "2016" I would like the entire row to be copied into a new worksheet titled "2016"
I would like to apply the same macro for years thereafter.