Exctract lines in sheet to another sheet based on text/names in cell

Hi!

As my long title says I am trying to figure out how to extract rows in a "master sheet" automatically to another sheet based on names (initials) in a coloumn.

The worksheet consists of multiple rows with multiple columns.
One of the coloumns will contain names. Some one name, others several - divided by commas.

If name X is present in row 6, coloumn D: is it possible to have Excel automatically transfer that row into a new sheet that is automatically named X?

If name X and Y is present in row 7, coloumn D: is it possible to transfer/exctract that row into sheet X (which was made after row 6) and into a new sheet named Y?

I hope that someone can help me out here!

Assuming header in row1.

Please Login or Register  to view this content.

Thank you for your swift reply!
I have attached a sample file.

I have not tested the code you gave me yet - I was not allowed to run it on my mac for some reason !?
Ideally i would like it to add a row to a designated sheet (by names given in the "Responsible" coloumn) as soon as a new row has been entered and a "Responsible" person is added.

Many Thanks!
It works very well!

I use a mac on work...

Is there a way to have the macro "run" continuously, or do i have to execute the macro manually each time to have it add rows to new sheets?

Not really sure what you are asking...
Here's my guess.
Function IsSheetExists must be remain intact.

Please Login or Register  to view this content.

Appreciate it!

Now the lines are duplicated in the new sheets.

Ill try to explain better:
When I am working in the master sheet and fill in new names (Responsible) in new rows I would like it (the macro (?)) to copy that line into its respective sheets without running the macro manually after each line I enter.

Maybe I have done something wrong, but i now have to link the macro to a button and run it for it to take effect.

Are you just adding and not deleting or clearing the data in master sheet?

No, I deleted everything except Function IsSheetExists...

You are misunderstanding my question...
1) to a standard module

Please Login or Register  to view this content.

2) Master sheet code module

Please Login or Register  to view this content.

3) ThisWorkbook code module

Please Login or Register  to view this content.

This enables you to update each sheet whenever you open a workbook or select any sheet other than Master.

I have made some changes to the sheet regarding to position of the different topics of cell. I tried to change the code accordingly, but I am afraid my skills are not that good.

Header is now in Row 1,2 and 3 (wrapped).
Name/responsible is starting on Row 4 and is placed in Column E.

Could you please point me to where in the code I can change these values?
I found out that I needed to change "For i = 2 To UBound(a, 1..:" to = 4

If your data layouts differs from what you have posted, no suggestion from me until I actually see the data layouts.

Thank you again for the new code

The Row is now transferred to new Sheet when I select and open a random sheet, but not when I start to write in a new Row.

Originally Posted by Generalist

Thank you again for the new code

The Row is now transferred to new Sheet when I select and open a random sheet, but not when I start to write in a new Row.

Why you want it so?
If you update "Master" and select other sheet, it will update....
To me, it is the same.

I agree, Jindon. It is a good solution!

I have made some changes to the sheet, causing the code to not doing what I need (see attached file).

Like I said in the previous post I am trying to change the correct lines in your code so it extract each row based on the name in coloumn D to a sheet with the same name as the name in D - Displaying the heading in row 1,2 and 3 as well.

To further complicate it I would like to extract the "risk"-cell in each row to its own sheet, with the info in column A also showing in the same sheet.

Any help is greatly appreciated.

Why do you need to merge row1 & 2?
If you want to manipulate the data, raw data range should not have merged cells.
It only gives you a problem.

Ok. The problem is that I am working in a already fixed template, so I have to adjust to it - not the other way around

............................

Thank you very much, Jindon!

One thing I cant figure out is why it doesnt exctract a name/line if I jump down to a random row.
Say that I start on row 4 and fill out to row 6, and then I jump to row 13 and start to fill in data. Then the row is not transferred to a new/its own sheet.
Any inputs?

once again, Thank you very much for your help.