COPY AND PASTE SPECIFIC ROWS

[HERNAN]

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

 

[Dave F]

There's no formula that copies rows.

You'd have to use VBA or else do it manually.

 

[Wiley]

A simple manual workaround is to sort the data by Col B. Then highlight all
the J rows and Copy/Paste to the new location.