If Cell = X, Then Copy Entire Row Into A New Sheet

You could try filtering on column C and manually copying and pasting the data into a new spreadsheet

Need to clarify something.
Is this a conditional behavior, ie. copy row to a new sheet IF certain criteria are met.

Or do you have several rows worth of information which you would like new sheets made, with the headers of each being named after that row's name.

An example workbook would be invaluable at this point.

I *think* that you want to go through all of column b, and for every cell that has a corresponding worksheet with the same name, add that information to the next empty row of that worksheet. If there is NOT a corresponding worksheet, do you want a new one made to suit, and continue on from there?

Okies right on, we're on the same page.

See attached file.

If the sheet name is going to have "my" at the beginning of it, you could modify the code to read from a mid of 2 to the end, that'd match it to everything after your "my". Currently it looks for exact text matches, and copies over the corresponding data. If no such sheet exists, it moves on.

Please Login or Register  to view this content.

You're going mad.
:D

When in design mode, double click on the command button,
or alternatively, just click on the "Visual Basic" button on the top left of the developer tab.

Let me know if you can work with that or if we need to go another direction.

Sounds like something more along the lines of the attached file may be what you're after.

There are all kinds of ways to go about this. You could even have it pop up three boxes asking for the criteria for page one, then two, then three, and have it run the search from there.

There's still al lot I don't know about how you want this to work. Do you want to clear the three targets each time a search is run, or would you like it to check for duplicates..? At the moment if you keep clicking the button, it'll keep adding to the list.

Or to eliminate the need to hop back into the code every time:

sry, haven't been on in a while.

Please explain when you want it to update. Could make it re-copy them all every time you changed which cell is active, but that's going to slow your sheet down a lot.

Personally I like buttons. I'd make it so that you check off/uncheck whatever you want and then have a button you press to run the update.

So, what's the plan.

Hello MewingKitty,

I am closing this thread because Alfonso83 should have started a new thread and not posted a related problem in another member's thread. If you want to follow up on this, I suggested you send Alfonso83 a private message or visitor's message and go from there. Not blaming you for this, we (the mods) missed this one.