Sheets in workbooks

[Guest]

Is there an easy way to have input information to a main sheet and if the
criteria is meet it would auto fill into another sheet. I have nine columns
with different information. If one of the columns meets the criteria the
whole row goes to another sheet. Like the name Bailey is in a certain row in
that column that whole row would fill in on another sheet.How would I do this?

 

[Dave Peterson]

Maybe you can steal some code from Debra Dalgleish's site:

There are a couple of files here:

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

Create New Sheets from Filtered List -- uses an Advanced Filter to create
separate sheet of orders for each sales rep visible in a filtered list; macro
automates the filter. AdvFilterRepFiltered.xls 35 kb

Update Sheets from Master -- uses an Advanced Filter to send data from
Master sheet to individual worksheets -- replaces old data with current.
AdvFilterCity.xls 55 kb