Hello, this is my first time on this forum and hoping someone can help me. I have a master database it includes names, addresses, program, etc. I want to create separate databases for each program. What I need help with is: How do I link the program name and the lines data and then have it repeat on a new worksheet (I think thats what its called) that relates to the specific program without having to re-type it?


ie: Master would include:
Name Address Program Email

I would continue to update the master list but want the information to then pull from over to the seperate tabs using the Program name as the connector (there are 6 programs)

Could you perhaps upload a file with examples of expected results?