VBA Loop with multiple conditions on one sheet

[LovePenguin]

Not sure if this is a duplicate question but couldn't seem to find it anywhere.

I have the following sample data:

	A	B	C	D	E	F	G	H	I
1	EMPLID	NAME	Dept	LOC	JOB TITLE	EE STS	EFFDT	HIST EFFDT	HIST EE STS
2	123	Doo, Scooby	564	564C	Driver	L	4/28/2018	3/20/2017	L
3	123	Doo, Scooby	564	564C	Driver	L	4/28/2018	3/15/2017	L
4	456	Jetson, Jane	531	531	Production	L	4/28/2018	6/2/2017	L
5	456	Jetson, Jane	531	531	Production	L	4/28/2018	2/20/2017	A
6	456	Jetson, Jane	531	531	Production	L	4/28/2018	1/6/2017	L
7	456	Jetson, Jane	531	531	Production	L	4/28/2018	2/20/2012	A
8	789	Bear, Grammy	501	501	Stockroom	L	10/18/2018	10/18/2018	L
9	789	Bear, Grammy	501	501	Stockroom	L	10/18/2018	4/16/2018	A
10	789	Bear, Grammy	501	501	Stockroom	L	10/18/2018	3/30/2018	L
11	321	Fraggle, Mokey	501	501	Production	L	6/2/2018	6/15/2007	L
12	321	Fraggle, Mokey	501	501	Production	L	6/2/2018	5/21/2007	A

<tbody>
</tbody>

What I need is a script for the following based on the sample data above:
I am trying to find the earliest date on a L row prior to an A.

So Jane Jetson is showing 2 separate L statuses. I need the earliest Hist EFFDt from the latest L status (ie: 6/2/17) to be placed in the farthest column to the right (doesn't matter which line but I need all other lines for the employee to either be blank or that date). Once it finds that it needs to move on to Grammy Bear. You will notice that Scooby Doo doesn't have any A status. Therefore I need it to recognize that 3/15/17 is the correct date I need not 3/20/17.

I think I need several DoUntil Loops in addition to some offsets. However, I am a total newbie at VBA with only basic knowledge of Macros and a few reference books. I can't seem to figure out how to put it all together.

Please help!