View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ron de Bruin Ron de Bruin is offline
external usenet poster
 
Posts: 11,123
Default 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?