Need to sort data based on criteria, and specific format

[wparker80]

First off thanks for all of the great tips and support so far. I have to send out weekly reports for my unit. The spreadsheet that says data as pulled is how it comes from the system that I pull the reports from. I have scrubbed the data of course. The second spreadsheet labeled Final report is how it is organized when it is sent out. Is there any way that I can have a macro assigned to sort the data and format as it is in the final report? I am open to all suggestions on how to best approach this problem. I can provide more examples just going to take time to scrub.

[cjo]

As your examples stand, I have no idea what the final report should look like. Do you think you could mock up a 'data as pulled' book with 3 examples, and a filled out 'Final report' book that shows the display for each of the three records from the 'data as pulled' book?

[wparker80]

I updated the Data as pulled spreadsheet to add two more sheets. All together there are 10 sheets in the workbook. Each one representing individual training. The number complete varies with each training from 10 - 500 personnel. Each person is assigned a Unit as depicted in the data as pulled. The last part of the unit is what I am interested in for example in the data spreadsheet the unit for Smith is PCD. If you look in the final report there is a section labeled PCD. I would like to copy the corresponding unit into the matching section in the Final report to make it easire to read for the End-user. I can sort differently and this does not have to be the way it looks. I updated the Final Report to show how the name would be displayed. If you need any further details please let me know. Right now I manually copy and sort.

[cjo]

I'm still not getting what's going on.
First, in your example please include a couple of more people, say Adam Black and Christine Dahl.

Secondly, on these 10 tabs from the initial data, is each person represented on each tab, or is it possible for them to be on only some tabs?

Third, on the final report sheet, are you filling out the other categories (DCA, HQ/BOD, etc), or just the PCD group? If you are, how are these identified from the original report? My guess would be that the UNIT ends with the appropriate category, but I'm not real confident guessing with a sample size of 1.