The item sample is in sheet 1
This has a field called bin #
Sheet 2 also has bin numbers and a sort order for each particular bin number. How do I merge these sheets so that the sort order on sheet 2 is maintained and sheet 1 is sorted according to sheet 2?
the actual item list is 8000 rows.