excel function for sorting by month

  • Thread starter Thread starter pboost1
  • Start date Start date
P

pboost1

I am having a little problem. I have a workbook at work and we need t
know who is coming due for the following month. We want a worksheet t
list seperately those that are coming due to avoid confusion. Thos
that have access to this workbook do not know excel that well.

example:

sheet one contains customer numbers in column A and there due date i
column H. we need column D of worksheet 3 to list those that ar
coming due.

Any help with this would be appreciated
 
Hi
why not use 'Data - Filter' for this. e.g. an advance filter to create
a separate list of your due recors.

Note: This is NOT dynamic of course
 
thanks, but I am not that familiar with the filtering of data. I am no
sure what to do? I did see the DGET function, but couldn't seem to ge
that to work either. my guess is I would need a "do/loop" or a
"if/then" statement but not sure how to write the function.

Again, thanks for any help that may be available
 
Back
Top