Filtering out Data

Jo Davis · Jul 7, 2005

Hi

i have a spreadsheet, were i want the user to input all data onto the first
worksheet.
I then want to be able to transfer, certain rows based on set criteria to
other worksheets.
Is this possible using any excel functions, or does it require me to use
macros and or programming

Cheers
Jo

Norman Jones · Jul 7, 2005

Hi Jo,

Use rhe Advanced Filter feature on the Data menu.

Debra Dalgleish has an excellent tutorial on Advanced Filter at:

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

Note particularly, Debra's instructions for 'Extractng data to another
worksheet'

Filtering out Data

Jo Davis

Norman Jones