Using formulas to filter information

[Anthony]

Hi
Our company uses a very large spreadsheet when putting an order on the
system most of this spreadsheet is not actually used so sorting
through it to find out what stock is actually required is a bit of a
nightmare.

I have not really used excel to much of a degree but I would think
that it is possible to right some sort of program to run on these
spreadsheets that will look at say the D column carry out an IF
statement to say IF D1=0 goto D2 if not copy C1 and D1 to another
spreadsheet this way producing a smaller spreadsheet which details
what is actually required.

I know this must be possible but have no real idea how to go about
doing it

Please can someone help

Regards
Anthony

 

[Norman Jones]

Hi Anthony,

Consider using the AutoFilter or Advanced Filter features.

If you are not familiar with these features, Debra Dalgleish has excellent
tutorials at:

http://www.contextures.com/xlautofilter01.html

and

http://www.contextures.com/xladvfilter01.html