branston
05-26-2020, 10:10 AM
Hi
Not having any joy with this so really hoping someone can help please.
I have a list of candidates with some associated data which I need to
1. copy data from 'candidates' tab
2. paste and sort into 4 groups
using VBA.
The number of candidates can change so the table in the 'groups' tab needs to be able to "extend" itself.
The candidate data (tab 2) itself is displayed in 2 parts (Columns B to D and Columns H to J). Ideally, once grouped into the relevant section, I need to distinguish between these 2 sets of groups. At the moment I have just used two colours (Orange Group and Blue Group).
I have attached my ***DUMMY DATA*** sheet and on the first tab I have shown part of how the end result should look like.
Can anyone help please?
Many thanks in advance.
Not having any joy with this so really hoping someone can help please.
I have a list of candidates with some associated data which I need to
1. copy data from 'candidates' tab
2. paste and sort into 4 groups
using VBA.
The number of candidates can change so the table in the 'groups' tab needs to be able to "extend" itself.
The candidate data (tab 2) itself is displayed in 2 parts (Columns B to D and Columns H to J). Ideally, once grouped into the relevant section, I need to distinguish between these 2 sets of groups. At the moment I have just used two colours (Orange Group and Blue Group).
I have attached my ***DUMMY DATA*** sheet and on the first tab I have shown part of how the end result should look like.
Can anyone help please?
Many thanks in advance.