I have 2 worksheets; LEADS & SALES
When any date is entered into LEADS H6:H1005, The information in LEADS B, C, D, E, F, & H6:1005
Will populate into SALES B, C, D, E, F & G6:1005 (The last column letter is different on LEADS vs SALES)
I do not want the info to auto sort based on any dates. I...