I have a workbook with about 10 worksheets, unfortunately they are not uniform either. I need only certain data from these worksheets that contain a 3 letter code in one of the columns. I need the whole row of information on a new sheet, if the column contains the 3 letter code, so I can create pivot tables and manipulate the data.
I tried IF and VLOOKUP and I think the only way to do this is with VBA. Does anyone have VBA code for this type of situation?