[vba] Organizing Data With Dates

[DataBlake]

I get a report that looks like this

Book1
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC	AD	AE	AF	AG	AH	AI	AJ	AK	AL	AM	AN	AO	AP	AQ	AR	AS	AT	AU	AV	AW	AX	AY
1	Sales Record Number	User Id	Buyer Fullname	Buyer Phone Number	Buyer Email	Buyer Address 1	Buyer Address 2	Buyer City	Buyer State	Buyer Zip	Buyer Country	Order ID	Item ID	Transaction ID	Item Title	Quantity	Sale Price	Shipping And Handling	Sales Tax	Insurance	eBay Collected Tax	Total Price	Total Includes eBay Collected Tax	Payment Method	PayPal Transaction ID	Sale Date	Checkout Date	Paid on Date	Shipped on Date	Shipping Service	Feedback Left	Feedback Received	Notes to Yourself	Custom Label	Listed On	Sold On	Private Notes	Product ID Type	Product ID Value	Product ID Value 2	Variation Details	Product Reference ID	Tracking Number	Global Shipping Reference ID	Ship To Address 1	Ship To Address 2	Ship To City	Ship To State	Ship To Zip	Ship To Country	Phone
2	10520	bobbert123	Bobbert Boberson	(123) 456-7890	reeeeeeeeee@gmail.com	123 Bobbert Ln		City	NY	34978-1018	United States		111111111111	111111111111	2 Boxes of Spaghettios	1	3000	199	0	0	300	3300	True	PayPal	A5F7R5FD6V3CX4S7F9	Sep-21-19	Sep-21-19	Sep-21-19	Sep-24-19	Economy Shipping	No			8004	eBay	eBay	hi…						1111111444444		123 Bobbert Ln		City	NY	34978-1018	United States	(123) 456-7890
3	10521	juniper1	June Ooga Booga	(321) 654-0987	hamburgerhelper@aol.net	1 E Circle St	APT 1	New York City	AZ	1234567	United States		121212121212	121212121212	1 Whole Live Cat	1	5	199	0	0	0	204	False	PayPal	8FA4S5D6F9S8A7S5	Sep-21-19	Sep-21-19	Sep-21-19	Sep-23-19	Economy Shipping	No			L5654887	eBay	eBay							161516151615		1 E Circle St		New York City	AZ	1234567	United States	(321) 654-0987
4	10522	loiuse371	Luis Misspell	(213) 465-8097	cooties@gmail.com	42124251523432123432123 Dr		Hell	FL	34990	United States		123123123123	123123123123	An Empty Box with 16 air	1	4000000	0	0	0	0	4000000	False	PayPal	ASDF56748GDSAS65487F	Sep-23-19	Sep-24-19	Sep-24-19	Sep-25-19	UPS Ground	Yes	Positive		ASDF-14224S	eBay	eBay							1815181518151		42124251523432123432123 Dr		Hell	FL	34990	United States	(213) 465-8097
Import

and i need to import relevant data to this format

Book1
	A	B	C	D	E	F	G	H	I	J	K	L
1	ORDERS - September 21 2019
2
3	NAME	ITEM #	PO NUMBER	QTY	Thing1	Thing1 Description	Thing2	Thing2 Description	Kit	TPMS	STATUS	NOTES
4	Bobbert Boberson	111111111111	st26Boberson	2	8004	2 Boxes of Spaghettios					Complete
5	June Ooga Booga	121212121212	st26Booga	1	L5654887	1 Whole Live Cat					Complete
6
7	ORDERS - September 23 2019
8
9	NAME	ITEM #	PO NUMBER	QTY	Thing1	Thing1 Description	Thing2	Thing2 Description	Kit	TPMS	STATUS	NOTES
10	Luis Misspell	123123123123	St26Misspell	16	ASDF-14224S	An Empty Box with 16 air					Complete
CustomerDATA

what i'm concerned with right now is the grouping data by date part. Everything else i can do and you don't need to worry about it.
basically the logic is to find unique values in column 26 of the "Import" Sheet (Sale Date) and separate the rows by the dates so that i can import/format the values
I was thinking a sort by date, count unique values and store that in a long variable, then loop through column 26 of the "Import" sheet until the value changes from the previous value and subtract 1 from the long, adding two rows to the "CustomerDATA" sheet.

but....i'm certain theres a better way

 

[DataBlake]

is there a way to use Index with unique values in VBA?
if i can just index the first unique value in column 26 that would probably make life easier