I'm new to this forum and also to macros so please excuse any technical slip-ups. Thanks in advance for help! I currently have two Excel workbooks, Child Data and Woman Data. I need to merge these two into one workbook, but with the caveat that not every woman in Woman Data is a mother of a child in Child Data. There is a column in each workbook for Woman(Mother)ID, and what I would like to do is create a filter such that I can export rows in Woman Data where the entry for Woman(Mother)ID matches an entry for Woman(Mother)ID in Child Data. Some women have more than one child, and so this also would need to be able to export some rows multiple times. For example, Child Data looks like this:
It is hard to see the data here. Could you post on some file sharing website a sample workbook and post back the link to the file here. The book should have some sample data that would be a good representative of your data. based on that book, could you also please re-explain the issue.