Need help getting row count dependant on 2 variables

Need help coming up with a script that will find the number of rows(related to invoices) for each vendor. Attached is a sample file that shows the how the data is formatted. Original data needs to stay intact, every thing is being return to a seperate tab. I need to get the row count starting from 3 rows down from each row that contains the text "Vendor" to the row before the row that contains "USD" or "--". The way I originally tried to get the count was like this

Please Login or Register  to view this content.

but it counts all the rows for the report.

vendor is defined like this

Please Login or Register  to view this content.

thanks in advance, s4

The goal is to build a database from a file similar to the sample file I attched. I am trying to write a macro that will accomplish that but I need a way to find how many records exist for each vendor so I can return the correct rows to the new database I am building.

do you know a way to return that value for each vendor? that would accomplish what I need. thanks