hello everyone.
I receive an excel file every morning and need to set up some automation to do a chore. This file has data for three different people on it, but is sorted by column P (has the persons name in that cell). I need to automatically sort and grab two of the people's data and create seperate files for each of them so that i cant send them to the appropriate person. it would be nice if each persons data was on seperate tabs(sheets) but it is not.

Anyone who can provide a remedy, please reply. I would be most thankful. I can do many functions with excel but this is out of my league.

To recap what i need help with... when the one file comes in, i need two additional files to be generated with each persons data and put in the corresponding file folder.


Thanks,