formula to move complete row if data matches in sheet 1 and 2 column 1 in separate sheets based on matching criteria in excel 2007
Sheet 3 = match data
Sheet 4 = no match data