easy way to Consolidate Data within one workbook's various workshe

[estimator]

Trying to copy data, that meets defined conditions, from one worksheet to
another worksheet within the same workbook in Excel 2003. Note: Please
simplify, I am not an advanced excel user. Thanks.

 

[Debra Dalgleish]

You can AutFilter the data, then copy and paste it. There are
instructions in Excel's Help, and here:

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

Or use an Advanced Filtr to extract the data. There are instructions here:

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