copy an entire row IF a statement is true
 

The first worksheet in my spreadsheet contains all of the data that I've
entered. I would like to create additional tabs that pull specific bits of
data out -- based upon inidivudal columns in the first spreadsheet (role
group, event name, etc.) Is there any easy way to do this?

copy an entire row IF a statement is true
 

Hi colettey29

Try the first example on this page that use AutoFilter
http://www.rondebruin.nl/copy5.htm


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"colettey29" wrote in message ...
The first worksheet in my spreadsheet contains all of the data that I've
entered. I would like to create additional tabs that pull specific bits of
data out -- based upon inidivudal columns in the first spreadsheet (role
group, event name, etc.) Is there any easy way to do this?