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

COPY AND PASTE SPECIFIC ROWS
 

There's no formula that copies rows.

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

"HERNAN" wrote:

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

COPY AND PASTE SPECIFIC ROWS
 

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.

"Dave F" wrote:

There's no formula that copies rows.

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

"HERNAN" wrote:

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