Hello all. I'm usually pretty good about piecing together VB scripts / macros to get what I need compiled but I'm at a loss and am hoping I can find help here. I have a large Excel file, one sheet (named 1-966) contains 6 columns of information with column A containing serial numbers. The second sheet (named lookup) contains a list of serial numbers in column B that should match up to some of the serial numbers in column A of sheet 1-966. The "advanced" portion is, if the serial numbers from the 'lookup' sheet are found in column A of sheet '1-966' I need that whole row that contains the matched data (columns, A,B,C,E,F and F) from sheet '1-966' to be copied to either a new sheet or to the 'lookup' sheet.
Basically, the 'lookup' sheet contains lost serial numbers of items whereas sheet 1-966 contains a master list of serial numbers in column A along with shipping dates, locations, tracking numbers, etc in columns B,C,D,E and F... this data needs to be exported to a separate sheet for analysis.
Thanks so much in advance.
Basically, the 'lookup' sheet contains lost serial numbers of items whereas sheet 1-966 contains a master list of serial numbers in column A along with shipping dates, locations, tracking numbers, etc in columns B,C,D,E and F... this data needs to be exported to a separate sheet for analysis.
Thanks so much in advance.
