View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pete
 
Posts: n/a
Default Copy between worksheets...

Apply autofilter to column 2 (usually called B) for values "Travel".
Highlight the displayed cells and copy them to another area of the
sheet - you can then delete the second column before copying to
Powerpoint.

Hope this helps.

Pete