Reply to thread

Message: [QUOTE="Cam, post: 6263289"] Hello Joel, I will try to explain as clear as possible. The date came from a raw data from sheet2 so every S/O has a date field. It is not the date where the entry is made. The raw data is pulled from our system so everyday the S/O can be obtained and will have higher operation number depending whether there are work done on that S/O, when all the operations are completed, it will have a "closed" status. No, it does not make any different if which 1st or 2nd column of each model. Yes, it is acceptable.I hope this explain what I am trying to do manually and hopefully can translate into macro automated. The No. column from sheet1 is the next product due for the customer. There are two difference models (100 or 200)for each No. There are 4 parts (1300 (2) & 1500 (2)) to complete each No. The raw data have S/O that are tied to 1300 or 1500 ref. Each S/O goes through 15 operations before it is completed. Everyday, the operation status of the S/O changes depending on what operation it is at. The important thing is that we want to make sure that we are working on the S/O with the right model for the next No. From the data below, the next No. would be 1002 which is model 200 (we skip No. 1001 because it is outsource to a vendor). The raw data would have S/O for model 200 at different operation status. The macro would than find the right S/O based on the model 200 and latest operation, then fill in 4 columns of each No. Everyday the operation for each S/O is updated once I pulled the raw data in sheet2. Thank for your help. [/QUOTE]

Verification