vba to dynamic timesheet on excel

[su_nandan]

Hello all,

I'm a vb newbie and have been struggling to solve a problem. Apologies in advance for the wall of text.

I'm trying to make a macro that will count the count and compare name (project Owner,member1,member2), project , project_Id from master worksheet then the "project" and "project Id will transfer individual worksheet belongs to "member 1 or member2 and project owner" in "project master" sheet.
If "status" opened the project will be transfer.

please give me a solution on this matter.

 

[yky]

I have found that with the new Mrexcel forum, the attached pictures are all blur, difficult to see. Perhaps you would consider posting a link to a better picture stored on the Internet.

 

[su_nandan]

this is the master sheet there are three 3 field (project owner, member1 and member2) belongs to project, project_ID and status. The project, project_ID and status are send there individual worksheeet.

 

[su_nandan]

this is the individual time sheet according to the allotted project