Forum Discussion
Comparing work sheets in two files
I am a novice when it comes to programing and this forum.
I am trying to compare two parts list to see what still needs to be ordered.
File A is the parts ordered list and file B is the parts needed.
Column B is the Material & column E is the Quantity
Is there a way see if the material in file A:A1 match B:A1 if it does, add A:A1 to B:H1. If doesn't move on to the next device in file B until it gets a match
If there no match create a worksheet that has the non-match material item with the quantity
Thanks
https://techcommunity.microsoft.com/discussions/ExcelGeneral/lists-comparison-stacked--keeping-order/4360997
Use a VBA macro in a separate workbook to compare two other files. This approach is common and keeps your VBA code separate from the data files.
The inserted file contains the VBA code. You can compare two files directly from this file.
You just need to click on the macro and select the two files you want and the comparison will be carried out.
Hope this will help you.
