Okay I now have a working sheet. The right hand columns get the info they need from the columns A,B,C. But the right hand columns could contain 100 rows or more as could the data columns A,B,C. How do you generate the Vlookup statement automatically in columns I and J. If I have to type each statement in I might as well just type in the data from columns B and C. Should I be using a pivot table instead or is it something that needs VBA?
|