Quote:
Originally Posted by MCS
use a sumif or a vlookup on the cusomer name to get the orders.
An Excel for dummies book (MS help sucks) can explain the vlookup funciton.
|
sumif and vlookup will not help adding new companies. sumif would be good if you were just looking for stuff you had to match. (customer on the side and brand along the top) and only if you didn't have a starting quantity you had to worry about. Otherwise you would have to make a presentation tab and a prior month tab or something similar.