Hi everyone,
I'm trying to get my workbook to automatically send certain information from my "combined" master sheet to other sheets within the workbook. I would like the program to recognize the initials of certain individuals in column C and place the information in that row on their corresponding sheet. I would also like to sort the Area in column D to the corresponding sheets. Column C is the workers initials 'KB' and the corresponding worksheet for this guy is Kevin Bu...
Im copying and pasting at the moment and I know there is a better way. I've been searching for a few days and cant seem to get the formulas correct.
Any help greatly appreciated. I have attached the file.
Cheers
Brent
Bookmarks