Copy & insert rows fom one sheet to another based on data in main sheet
I have been trying to solve this problem but canít seem to. I would be grateful if one of you awesome excel users would be able to help.
I have attached a sample sheet below.
I have one main sheet called Project Details where I want to input all data.
In the sub-sheets i.e (Jhon, Adam, Josh,Katy..etc) I only input the headers.
I want to create a macro so that in the main sheet (Project Details) any Column from C to F that shows Jhonís name, that whole row will be moved into Jhonís sheet.
For example, Row 7 shows Jhons name is cell C7 so I want the whole of row 7 from (A to O) to copy into Jhons sheet using the macro.
Similarly, Row 8 shows Jhons name is cell D8 so I want the whole of row 8 from (A to O) to copied into Jhons sheet
Since Jhons name isnít in row 10, that row will not be moved into Jhons sheet.
I hope that makes sense and one of you will be able to assist me.
I am new to VBA, I created a macro but canít seem to make it work.
All your help will be truly appreciated.