my first part of my code works to transfer data from FA USE to LOG but i am trying to get the QATRangeCopy to look up SN# from worksheet QAT USE and then copy an paste new data to the log based on the SN#
i have tried several different Vlookups but cant get it to work keep getting errors or nothing happens