Attached are two files, one with source file and the file with results. Below is what is expected:
1- It sorts by ETA (column O) from oldest to newest. At the same time and as a second level, it sorts by ItemNUmber (column I)
2- It put thick outside borders for each merged ETA (cells)
3- Merge cells only in Column O and Q
4- In column Q is the week number (a week is considered from monday to sunday). If the ETA in column O falls in monday and tuesday, the Week number must be that week e.g. if it was Sep 19th, it should be W38, but if ETA falls in wednesday or after, the Week number would be in this case W39.
5- Highlight all merged cells after Q2
Note, rows may vary also there are three segments ONLY Asia, Americas and CAD. These may be more than only three. Between each segment e.g. Asia and Americas we may have 3, 2 o more empty rows, they vary.
Both file does not have the exact information, I simply added them as examples.
Thank you,