Hey guys,
I need your help here, please see the data spreadsheet I've attached, on this document, I'll be pulling data that updates over time. The problem is sometimes orders stay the same but dates might change. therefore if I pull the data on Monday (example), on the Thursday if I pull again this these are the variables:
- Completed orders will be eliminated from the list
- New Orders will be added
- Some pending orders might change dates
- The pending orders that were data pulled Monday will still be on the new data pull Thursday
With that scenario, since the data eliminates finished orders, I don't have a history. So I'm uploading and adding to this spreadsheet, but the lines that duplicate because they are pending orders, or orders that only changed due to a date change, I need to be able to identify, so I can delete from the full list.
This will be thousands of lines of data over time, so checking manually is close to impossible, preferably I'd like to have an additional column that does the check, and returns a value of either "", or "Duplicated", this way I can filter them all together, and delete them.
Best option, but I don't know macros to do so, would be upon pasting the new data lines in, to eliminate the previous lines that match.
These are the matching columns PER ROW that need to be checked:
- SO No
- Prod_ Order No_
- Build Number
- Item No_
The check would be to see if any 2 or more rows match on those listed columns.
Bookmarks