I've attached an example of what I'm look to do if the explanation I give isn't clear. I have a workbook with multiple sheets. The main sheet contains a lot of data that gets updated, usually once a week. There are a number of other people that also use this to pull certain information out. So, I'm looking to setup the workbook so that the person's name is tied to a particular worksheet and that any information where their name is listed is copied to that sheet. Basically sorting on their name and copying it to their particular sheet. Is it possible to do this automatically? Thanks for the help. I don't know much excel programming so this one is a bit out of my scope.
Matt
Bookmarks