Arranging data that is in columns in a different dynamic way

[branston]

Hi Ken

Thanks for replying.

By dynamic I meant that the list can change length depending on the criteria in columns C and O.

Yes that's all I need.

The problem I have is that if I cut and paste group 3 under group 1 and group 4 under group 2 ... when the macro for group one is run it overwrites everything in columns Y and Z i.e. overwrites group 3. I need it to stop after the last candidate in group 1 and when the macro for group 3 is run... for that to return values in a few rows below wherever group 1 stopped. Same for group 4 and group 2. (At the moment the values where group 3 and 4 start are 'hard coded' and obviously these need to be 'relative' according to where the previous groups finish/stop.)

I hope that makes sense. I thought it was a simple enough problem but couldn't sort it so left the data in four group columns for you to see.

Also I have 8 macros running to sort these 4 groups out. 4 for the group lists and 4 for the associated pics. I'm not sure that is the most efflcient way of doing it?

Thanks once again