I have a worksheet with about 57 columns worth of data. All the data in each row is relative to the item number in Column E. I have another column worth of data in the same workbook but on a different worksheet. This data in worksheet 2 is the same as the data in worksheet 1 column E, but there are several item numbers missing. What I need to know how to do is somehow sort the data so that based on the data in sheet 2, sheet 1 sorts all the rows so that the data is in the same order as sheet 2 and any rows with data in sheet sheet 1 but not sheet 2 are either eliminated or moved to the bottom, top, or elsewhere so that I can remove it from the worksheet.

Can anyone tell me if this is possible and how to do it? Please contact me if you need more info.