View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
HERNAN HERNAN is offline
external usenet poster
 
Posts: 103
Default COPY AND PASTE SPECIFIC ROWS

Example:

A B C

1 Nick 10
2 john 15
3 jenny 15

Using a formula how do I copy and paste in a different place the rows of the
names that starts with "J" in this case row 2 and 3.


Thank you in advance. I'm getting crazy with this project