Complex VBA to copy and paste based on 2 columns and different criteria

[thedeadzeds]

Guys, not even sure if this is possible.

I have an excel table called 'Newport' which consists of the following 9 columns:


Dealer,
DecsR
Attempt - (this column will only consist of New, 1st, 2nd and 3rd)
RegNO,
Salute,
Updated,
Contdate,
Completecode


The table normally has around 2000 records. Is there a way to do the following:


Find The oldest 2 results based on 'Attempt' by each 'DescR' based on the oldest ContDate.

So out of the 2000 records copy 2 of each Attempt for each DescR to tab 'Blue'. If there is not 2 then copy what is there.

If this is possible, Is there a way to base the volume (ie 2 in this example) on whatever number is in cell a5 on the menu tab.


See expected results below: So in this we are showing the oldest New Calls based on contdate for Each DecsR, The oldest 1st based on contdate for Each DecsR, the oldest 3rd based on contdate for Each DecsR and so on

Dealer	DescR	Attempt	RegNo	Salute	Updated	contdate	completecode
BAA	SE1	New Calls	1	Mr Jones 1	01/01/2018	01/02/2018	CUA
BAA	SE1	New Calls	2	Mr Jones 2	02/01/2018	02/02/2018	CUA
BAA	SE1	1st	3	Mr Jones 3	03/01/2018	03/02/2018	TEA
BAA	SE1	1st	4	Mr Jones 4	04/01/2018	04/02/2018	CUA
BAA	SE1	2nd	5	Mr Jones 5	05/01/2018	05/02/2018	LMS
BAA	SE1	2nd	6	Mr Jones 6	06/01/2018	06/02/2018	CUA
BAA	SE1	3rd	7	Mr Jones 7	07/01/2018	07/02/2018	CUA
BAA	SE1	3rd	8	Mr Jones 8	08/01/2018	08/02/2018	CUA
BAA	SE2	New Calls	9	Mr Jones 9	09/01/2018	09/02/2018	CUA
BAA	SE2	New Calls	10	Mr Jones 10	10/01/2018	10/02/2018	CUA
BAA	SE2	1st	11	Mr Jones 11	11/01/2018	11/02/2018	CUA
BAA	SE2	1st	12	Mr Jones 12	12/01/2018	12/02/2018	CUA
BAA	SE2	2nd	13	Mr Jones 13	13/01/2018	13/02/2018	LMS
BAA	SE2	2nd	14	Mr Jones 14	14/01/2018	14/02/2018	LMS
BAA	SE2	3rd	15	Mr Jones 15	15/01/2018	15/02/2018	CUA
BAA	SE2	3rd	16	Mr Jones 16	16/01/2018	16/02/2018	CUA
BAA	PWB	New Calls	17	Mr Jones 17	17/01/2018	17/02/2018	CUA
BAA	PWB	New Calls	18	Mr Jones 18	18/01/2018	18/02/2018	CUA
BAA	PWB	1st	19	Mr Jones 19	19/01/2018	19/02/2018	CCB
BAA	PWB	1st	20	Mr Jones 20	20/01/2018	20/02/2018	LMS
BAA	PWB	2nd	21	Mr Jones 21	21/01/2018	21/02/2018	CUA
BAA	PWB	2nd	22	Mr Jones 22	22/01/2018	22/02/2018	LMS
BAA	PWB	3rd	23	Mr Jones 23	23/01/2018	23/02/2018	LMS
BAA	PWB	3rd	24	Mr Jones 24	24/01/2018	24/02/2018	CUA
BAA	PWS	New Calls	25	Mr Jones 25	25/01/2018	25/02/2018	CCB
BAA	PWS	New Calls	26	Mr Jones 26	26/01/2018	26/02/2018	CUA
BAA	PWS	1st	27	Mr Jones 27	27/01/2018	27/02/2018	CUA
BAA	PWS	1st	28	Mr Jones 28	28/01/2018	28/02/2018	CUA
BAA	PWS	2nd	29	Mr Jones 29	29/01/2018	01/03/2018	LMS
BAA	PWS	2nd	30	Mr Jones 30	30/01/2018	02/03/2018	LMS
BAA	PWS	3rd	31	Mr Jones 31	31/01/2018	03/03/2018	LMS
BAA	PWS	3rd	32	Mr Jones 32	01/02/2018	04/03/2018	CUA

<tbody>
</tbody>