Arranging data that is in columns in a different dynamic way

[branston]

Hi

I have some candidate names and their photos arranged in 4 'group columns'. I want to arrange the candidate names/photos in a 2x2 arrangement where groups 3 and 4 are 'underneath' groups 1 and 2.

I am having 2 problems.

Firstly due to the way the code is written if for e.g. Group3 is placed underneath group1, group3 will be overwritten when viewing/running macro for Group1 candidate pictures. Second - Each group list is dynamically generated (so its length can change). I therefore need the 2x2 table format to adjust according to the size of the list and Group3 and Group4 lists to start a few rows after the 'lastrow' of Groups 1 and Group 2.

I appreciate that it is easier to do this using the 4 group column method but that is not how I need the data presenting.

I have attached my file (irrelevant data stripped out) and would greatly appreciate it if anyone can help.

Thanks in advance