Hey guys will try to explain as best as possible to what I am trying to accomplish. I have a row of columns named OEM and separate rows for clients. I have indicated in the rows as to which clients have access to which OEM. In some cases a client may have access to multiple OEMs. So what I am trying to do is create a separate sheet for each OEM and then bring over the client list automatically as new clients and new OEMs are added to the workbook. Is this possible and if so how do I accomplish it. Thanks in advance for any help or ideas.
Capture.JPG
Bookmarks