I would like to know if there is a way to transfer the data in column A,B,D,G to Sheet2 and Sheet3? I would like to have all the even locations in column A transferred to sheet2 and all the odd locations in column A transferred to sheet3 if possible. The only thing the will change in column A is...