Hi all,
I have a large datafile written in Excel that contains data concering faulty parts from Vendors. I am trying to write a program that takes this data and split it up based on each vendor. so far I have been able to open the file and perform a filter, then select the 1st vendor copy to another spread sheet and save. what I am having trouble with is then selecting the next vendor. normally I would just select vendor individually however some weeks some vendors have no issues, so their data isnt published. Would anyone know if its possible for what Im trying to do to actually work from with VB?

I can post the code or if anyone can suggest a method to use id be very thankful, I was thinking something like an array, but that would mean being able to calculate the number of vendors (not the total number of rows)

Any suggestions?