I have a data set that I currently filter on (Data/Column B) and then email that sheet out to that individual. I have two tabs. The first tab is the data, the second tab is a user list (Column A) and email list (Column B). I manually filter Data/Column B on User/Column A, email to User/Email Column B, and then go back thru (A2 to A50). I'm looking for a loop code that I can run that will grab filter my Data/Column B by UserList/A2 and then email it to UserList/B2, and then loop through until I've filtered/sent on all users. Can anyone give me a jumping point to start from?