If Function - Date Problem

  • Thread starter Thread starter JEM
  • Start date Start date
J

JEM

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

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

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

The info source is actually two sheets as well, just to make thi
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 dat
from both sheets into a monthly total, completing all calculations a
once?

Any thoughts before I provide specifics of the functions I hav
running? I'm sure I'm just being a numpty! :rolleyes
 
If your sheets are set up like databases - a single row of column headers in
row 1 and data commencing in row 2, then you should explore the Data>Import
External Data>New Database Query menu options. You can create a query or
queries against your Excel sheets to pull specific rows of data into a new
sheet or a 'master' calc sheet. Changing the query parameters to pull in the
next set of data is relatively easy, too.
 
'The info source is actually two sheets as well, just to make thi
worse'.
<<< a link in this page tells how to use a union statement to create
view that contains the data from both sheets
http://www.contextures.com/xlPivot08.html

'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 dat
from both sheets into a monthly total, completing all calculations a
once?'
<<<< if you double-click on any pivot-table value, a new worksheet wil
be created that displays all records in that total. Would that provid
a solution
 
Back
Top