I have a list of sales information and I just want to extract a
particular customer's sales but as individual lines, not a total.
Currently got an If function running per line that returns either the
info required or a 0, so I have to filter that sheet to hide the 0
lines.

Ultimately I need to extract this info monthly to perform some
calculations on. Having real trouble with the IF function to limit the
results to particular months. Oh, and I'm still filtering at this point
too!!

Is there an easier way of doing this, perhaps in one function from the
original sales sheet. Just to extract this customer's sales info per
sale line into monthly tables?

The info source is actually two sheets as well, just to make this
worse.

I've looked at pivot tables but they just seem to provide totals.
Perhaps I could create a table that takes one month's worth of data
from both sheets into a monthly total, completing all calculations at
once?

Any thoughts before I provide specifics of the functions I have
running? I'm sure I'm just being a numpty!


--
JEM
------------------------------------------------------------------------
JEM's Profile: http://www.excelforum.com/member.php...o&userid=35124
View this thread: http://www.excelforum.com/showthread...hreadid=548814