Copy entire row from one worksheet to another

December 15, 2011 at 05:21:21
Specs: Windows XP
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

example:
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.


See More: Copy entire row from one worksheet to another

Report •

#1
Report •
Related Solutions


Ask Question