vlookup newbie question

[a911er]

Hi I have a spreadsheet that is used to keep track of parts taken by
sales reps. It has dates on the left column and approx 80 other
columns corresponding to the individual parts. each parts column can
have a vlue of 0 , 1 or more depending on how many parts they have
taken on that day. What I am trying to do is (on another sheet) is
enter a certain date and have it return a chart of parts taken that
day(zero parts coumns excluded). this is for the purpose of giving the
reps a sheet detailing just the parts they took that day. Is vloookup
the best way, and HOW or is there a way to make this update happen
automatic on the second sheet.
thanks for the help

 

[Dave Peterson]

It sounds like a pivottable might be a better fit.

You can do all sorts of summaries of numeric data (based on dates/text/or even
numbers).

Here are some links for pivottable info:

Debra Dalgleish's pictures at Jon Peltier's site:
http://www.geocities.com/jonpeltier/Excel/Pivots/pivottables.htm
And Debra's own site:
http://www.contextures.com/xlPivot01.html

John Walkenbach also has some at:
http://j-walk.com/ss/excel/files/general.htm
(look for Tony Gwynn's Hit Database)

Chip Pearson keeps Harald Staff's notes at:
http://www.cpearson.com/excel/pivots.htm

MS has some at (xl2000 and xl2002):
http://office.microsoft.com/downloads/2000/XCrtPiv.aspx
http://office.microsoft.com/assistance/2002/articles/xlconPT101.aspx