Macro to copy and paste

B

Brian

I am looking to copy and paste three rows if a cell in
column A = a referenced cell. For example

Column A of Sheet1 has last names
Cell A4 of sheet2 is where a last name is entered by
user
If the last name in A4 matches a last name in
Column A of sheet1 the row the name first appears on
plus the next two rows should be copied to row 100
of Sheet1

I'm not familiar with MVB so any help is greatly
appreciated.

Thanks!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Create if partial match then copy and paste data from one cell to another 1
loop to copy paste 5
Copying row into new sheet if it contains certain text 8
Array with many cells from a row but not in order or together 11
conditional formatting, filtering then copying to another sheet 0
loop to copy paste 3
OnTime Change_Event macro AND copy to sheet2 macro trouble 7
Match columns to rows then loop. 2

Top