VBA Assist with a Summary Table

[sachavez]

Excel 2016

Looking for some code that will create a summary table in Columns D/E, at the end of USEDRANGE (plus one row). The table would summarize the number of unique values in column A of USEDRANGE.

Here's how I'd like for the summary table to look (keep in mind, the number of unique values changes each day).

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Value[/TD]
[TD]Count[/TD]
[/TR]
[TR]
[TD]806[/TD]
[TD]15[/TD]
[/TR]
[TR]
[TD]807[/TD]
[TD]29[/TD]
[/TR]
[TR]
[TD]808[/TD]
[TD]13[/TD]
[/TR]
[TR]
[TD]Total[/TD]
[TD]57[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

Thanks in advance!

Steve