Quick Macro - Copy and Paste into sheet #3

[pklimchuk]

Hello

Looking for a Macro

IF A2 = "BOB Smith"

Copy the eniter row and paste in sheet #3

 

[jbeaucaire]

Are you then going to go down the entire column A? Is sheet #3 named "Bob Smith" to match? Are there other names to go to other sheets?

'SHEET1 TO MANY SHEETS
Here's a macro for parsing rows of data from one sheet to many sheets named for the same values in a specific column.

Sheet1 to Many Sheets​

It not only can parse the rows, it can create the sheets if they are missing. There is a sample sheet there where you can test this out.

 

[pklimchuk]

Yes all the way down A

 

[jbeaucaire]

Then that's the macro for you. It's already set to parse by column A, it sounds like you row1 is "titles" like it needs to be for the AutoFilter to work cleanly.

The only thing you'll need to edit on the macro before running it is setting the correct sheet name. Either change your sheet name to "Data", or edit this line of code to match your data sheet name.

'Sheet with data in it
   Set ws = Sheets("Data")

 

[pklimchuk]

Your Macro just makes a copy of my entier sheet.

I need a macro: in an active worksheet

when it finds "bob Smith" make a copy of that row and paste it into a new worksheet.