![]() |
#6
|
|||
|
|||
![]()
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?
|
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Pivot Table Question- Can the table display in the order the boxes were checked/selected? | blackjack | Excel | 0 | 09-13-2014 08:57 PM |
Pivot table help | TishyMouse | Excel | 2 | 04-27-2012 10:19 AM |
![]() |
aliasadi_07 | Excel | 1 | 03-11-2012 12:49 AM |
![]() |
natsha | Excel | 1 | 02-16-2012 12:41 PM |
![]() |
Karen615 | Excel | 5 | 08-03-2011 10:46 AM |