Merge 2 files and delete duplicate
Hello Guys,
I have 2 files both have data actually I am getting file everyday,
We will call Yesterday file (File1.xlsx) and Today's file (File2.xlsx), both have some fields like prodcutId, Price Quantity and more
We have 2 fields are important here... 1) ProductId and 2)Quantity
Macro done be for like : Open both file and copy data from File1 (Yesterday's)file and paste into File2 (Today's File)
Condition is that If you found prodcutId Duplicate then Remove whole raw and rest all data's Quantity must be '0' (don't forget - Quantity Must be 0 from Yesterday File, not from Todays file)
Rest all data would be there and New data (todays file data) would be under of the Old data
Pls find 3 files here
1) File1
2) File2
3) Output
Check Output and also see both File
Thnking you
Attachment | Size |
---|---|
File1.xlsx | 8.29 KB |
File2.xlsx | 8.34 KB |
Output.xlsx | 8.43 KB |
Recent comments
6 years 3 weeks ago
6 years 41 weeks ago
7 years 1 week ago
7 years 4 weeks ago
7 years 5 weeks ago
7 years 10 weeks ago
7 years 18 weeks ago
7 years 19 weeks ago
7 years 19 weeks ago
7 years 19 weeks ago