I am trying to figure out a way to copy a row from one worksheet to another when a cell has a value in it. I am not new to excel but I have never done anything with Macros before and I am very confused. I added the file I'm trying to do this with. If colum K has a value in it I want that row from K : P to be copied to Sheet2. Thanks for the help if you're able!