Total Instances of Same Value in Column A into Column B - Value ALWAYS Varies

Hello and thank you for your help in advance!

I am pulling RAW Data from a reporting system, I only need 9 columns of the 35 that are pulled, I have removed the unwanted columns and totaled columns that need to be totaled using SumIF's and CountIF's. All is good there; here is the problem I am facing...

Column A will have up to 300 different values i.e. 1739 is the value but shows up multiple times or 1767 only one time, thing is, each time the report is pulled, these values will be different. The Header for this value is called "Order Number". In column B (which has been inserted after unwanted columns are removed), I need it to total the amount of times; each Order Number has come up.

Column A is what the RAW Data is sorted in, Column B should show 8 (or whatever the total is), adjacent to the first or last instance of the Order Number.

Also, I need this all to be in a template or macro or something so that is can be used on a daily basis. Thanks!

Here is an example of what I am referring to:
[TABLE="width: 185"]

[tr]

[td]

Order Number

[/td]

[td]

Total

[/td]

[/tr]

[tr]

[td]

1739

[/td]

[td][/td]

[/tr]

[tr]

[td]

1739

[/td]

[td][/td]

[/tr]

[tr]

[td]

1739

[/td]

[td][/td]

[/tr]

[tr]

[td]

1739

[/td]

[td][/td]

[/tr]

[tr]

[td]

1739

[/td]

[td][/td]

[/tr]

[tr]

[td]

1739

[/td]

[td]

6

[/td]

[/tr]

[tr]

[td]

1758

[/td]

[td]

1

[/td]

[/tr]

[tr]

[td]

1759

[/td]

[td]

1

[/td]

[/tr]

[tr]

[td]

1760

[/td]

[td]

1

[/td]

[/tr]

[tr]

[td]

1761

[/td]

[td]

1

[/td]

[/tr]

[tr]

[td]

1762

[/td]

[td]

1

[/td]

[/tr]

[tr]

[td]

1764

[/td]

[td]

1

[/td]

[/tr]

[tr]

[td]

1765

[/td]

[td]

1

[/td]

[/tr]

[tr]

[td][/td]

[td]

[/td]

[/tr]

[/TABLE]