Copy and paste from random order to alpha-numeric order

Hello all
I suspect this is a very simple one for those who actually know what they are doing, but I could really use some help.

I have a Workbook that contains 2 Sheets ("Names" & "Allocations"). In "Names" I have a list of Student Names in Col B, the student Gender in Col C and a Position (1A/1B/1C - 10A/10B/10C) in Col D. These are in no particular order. In "Allocations" I have the fixed Positions of 1ABC - 10ABC.

What I am attempting to create is a macro that will take the list in "Names" and paste the name and gender alongside the respective Position in "Allocations".

I have attached a workbook for clarification but, as I have tried various approaches and ended up with a mess only, I have not included any code.

I would really appreciate your help.

Many thanks
John

Maybe :

Please Login or Register  to view this content.

Wow. Awesome!
That is exactly what I was after. Thank you so much for your help karedog.
Cheers
John

You are welcome, glad I can help.


Regards

Hi karedog

I am having a slight problem using this code when the "Allocations" sheet is protected (with the particular target cells unlocked). Seems to be due to the use of CurrentRegion. Any suggestions?

Many thanks
John

You can use this modification code :

Please Login or Register  to view this content.

That certainly has resolved the issue. Thanks karedog.
I do still have one issue that I am struggling with if you still have the patience for it.
I was hoping to be able to adapt the code so that it would achieve something like:

Please Login or Register  to view this content.

I'm so sorry for the changes - I thought I would be able to make the adaptation myself.

Thanks again for all your help.

I cannot work without real file, so please upload your newest file with all data needed to solve it.

Hi again karedog
Here is the attached file. As you will see, Cell A1 on the "Names" sheet has a drop-down of different classes. The sheet that the list is copied to should be determined by this value. Each configuration on the different sheets is a bit different (I did successfully adapt for "Allocations1" in Test3 macro). I wonder, also, if I could place in a check for duplicates within the original Positions column on the "Names" sheet..?
Any help that you could provide would be enormously appreciated.
Thanks (yet again).

It seems I have resolved all issues and requirements. I will post full code (once I have tidied it up a little) for any requiring it in future.

Thank you very much for all your assistance karedog.

Here is the Workbook containing the final code for anyone interested.

The macro - searches list on "Names" sheet checking for duplicate positions then determines which macro to call (as different one required for different destination sheets) based on cell A1 in "Names" sheet. Calls the appropriate macro within that and transfers name and gender to the appropriate sheet.

Many thanks to karedog and others for their help.

Hi John, sorry for the late. I see that you have solved the new issue by yourself.
Keep up the good work.


Regards