1 2Sheets("V9").Columns("A:D").Value = Sheets("RawData").Columns("F:I").Value 3 4 5See the smart part , it's opposite of the copy command which requires me type 6the source before and don't give me values