If you use "entirerow.copy" in VBA, you must paste it starting in column A of any sheet. You cannot paste it starting in column C. Your best bet is to copy and paste the range in Sheet1.