Hi Folks,
I wish to copy a defined range---G2:G12000 from sheet1 into D2:D12000 on sheet2. Sounds simple right? However, Sheet 1 arrives each day with an inconsistent column order: Column G (sheet1) is sometimes Column D, Column H or Column J etc. Problematically, the header name is not...