Excel VBA display the most frequent value in a range that changes based on blank row

[barbarao]

Hi, Excel VBA question. I have a spreadsheet that shows employee types per company. Each company has a blank row after the last employee. I need to write some code that will look at column H (the employee type column) and insert the most shown employee type for that company. Does anyone have any idea on how I can do this? Thanks in advance.

[ADezii]

In this case, inserting a graphic of the Spreadsheet, or attaching it with some sample data would be most helpful.

[barbarao]

A sample had been given the other day.

[barbarao]

Ooppp..guess i didn't post the sample. Here it is.

Company# CoName AgesServed Web Specialty Second Specialty TaxID JobTitle JOBID

793 AFC Adults and Children TRUE 2 Temp 08
793 AFC Adults and Children TRUE 2 Clerk 50
793 AFC Adults and Children TRUE 2 Clerk 50
793 AFC Adults and Children TRUE 2 Clerk 50
793 AFC Adults and Children TRUE 2 Clerk 50
793 AFC Adults and Children TRUE 2 Janiter 48
793 AFC Adults and Children TRUE 2 Manager 99

539 OGAssoc Adults Only TRUE 55 Clerk 50
539 OGAssoc Adults Only TRUE 55 Trainee 16
539 OGAssoc Adults Only TRUE 55 Trainee 16
539 OGAssoc Adults Only TRUE 55 Trainee 16