List info if criteria is met?

L

Lynn

From my check register I would like to list the outstanding checks in order
to reconcile. How can I have the outstanding checks listed on another sheet
in the file?
 
R

Roger Govier

Hi Lynn

Without bothering to move them to another sheet, why not mark your
header row, Data>Filter>Autofilter and use the dropdown on the
reconciliation field to select just the blanks.

If you do want to move them to another sheet, Used Advanced Filter.
Debra Dalgleish has some excellent instructions at
http://www.contextures.com/xladvfilter01.html
 
B

Biff

Hi!

You need to provide a much more detailed explanation.

For example:

Where are the outstanding checks?
How do you know they're outstanding? You obviously "mark" them when they've
cleared. How do you mark them? Where is the mark?

What exactly do you want listed? The check numbers? The amounts? Both? The
total amount of all outstanding checks?

Where do you want to list this data?

Biff
 
Top