Copy rows based on the value in column A

[Chuck_Fickens]

Hi

I've been looking at this for 30 mins now and think I'm over complicating things in my head and getting nowhere.

So thought I'd come to the experts

I need to copy the entire row from one sheet to another (or several) based on the value in column A

so in column A i have staff names John Bob, Sally, Sue and Felix (names have been changed to protect the innocent)

how would I copy all rows for Sue onto another sheet. then for Felix on another sheet and so on....

If I changed the data on the any sheet it would change all, (thats not vital, but useful)

the data will be constantly added on the first sheet and the named sheets would need to update.

any takers?

Thanks in advance.

let me know if you need anymore info to assist.

Chuck (not my real name either)

[Pete_UK]

If you post an example file I can show you how to do it using a few formulae - you can continue to protect the innocent, but just include dummy data in all the columns that you use now, so I can ensure that I pick up all the data.

Pete

[Chuck_Fickens]

Book1.xlsx

so this would be a basic example of how it will look / function

at this time the sheet I'm using is 1000's of lines deep, and about 30 col's and I have 3 managers to assign.

I've done this using filter / link, but for some reason the sheet I have doesn't filter after a certain line and I don't want to run the risk of copy and pasting the same line twice.

would the named sheets update when i save new info on the main sheet?

Thanks very much for helping.

I can have the actual sheet I use tomorrow as its in work, if it helps, but its mostly numerical and dates that is being entered.

[Pete_UK]

You have names missing in column A of the master sheet, e.g. in A7 and A8. Are these meant to represent that Paul (in A6) is also doing or is responsible for those tasks?

I think those cells will have to be filled with the appropriate name, to avoid any ambiguity - is there any problem with that?

Also, you have two grey rows (13 and 19) which are not really part of the data - do you have many more of these in your real file? Could we use another field to indicate the type of work (Current, Other, Older perhaps) and remove the grey rows?

Pete

[Chuck_Fickens]

the lines with missing files are just unassigned as yet, untill more is know then they will be assigned to someone, I suppose we
could have unassigned in there if it helps with filling the box

the grey rows represent lines i have for work that is current, work that is complete and invoiced and work that has been tendered and awaiting instruction, so its 3 sperate sctions I could turn these into seperate sheets for these, this might make the sheet more readable, I'll make a copy of the actual sheet tomorrow and upload, might be better than a lot of if, buts and maybe's and give you a better idea of the layout

[kvsrinivasamurthy]

Pl see the attached file. Is this what you are looking for.