New to the forum and need assistance with automatically transferring rows of data

[gotwheat]

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,

[vlady]

Welcome to the forum.
You can create a thread in the subforum "Excel Programming/vba/macro" and i think better post a sample workbook there.

To attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are demonstrated, mock them up manually if needed. Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic