Array Question

[TheShaunMichael]

Hi all,

Have an excel sheet I use to create estimates (each new estimate goes in row 2). Each time I create a new estimate, a row is inserted into column 2 pushing all previous records down. I have about 800 rows now. For each estimate/row, the company name is in Column A.

Ultimately, I need to create an array that returns a list of all unique company names. The challenge is, in my list of 800 estimates, company names in some cases appear 30 or 40 times whereas others appear just once.

I obviously need some type of If then loop to test for existing values within an array. If the value in column A doesn't exist, the value needs to be added, and if it does exist the loop needs to move to the next row.

Many thanks!

 

[Norie]

Rick

I think the problem has something to do with RowCount.

 

[TheShaunMichael]

I'll send over a book of data. The sensitive data to which I refer is customer data. In many cases I have NDA's with these folks so it's nothing personal!

Also, do you have any experience having Excel/VBA create documents in Word? So I have 800 rows of company data, now I want to automatically create an estimate/quote in Word (essentially mail merging on steroids). Let me know if you know anything about that or if you know of a good source!