1st sheet name = Source;

Columns in 1st sheet = Name, Projects, Status;

2nd sheet name = Volume;

Columns in 2nd sheet = Name, Max number of Projects;

3rd sheet name = Target;

Columns in 3rd sheet = Name, Projects, Status;

I am very new in Google Apps Script and I need your help here. We have our input data in the source sheet and in the volume sheet, Manager can provide the name and the max number of projects the person can work on. Based on that, the resultant data will get pasted in the Target sheet.

Means for name ‘abc’ if the number of projects listed for ‘abc’ is 10 in Source sheet but in the volume sheet if ‘abc’ is has been assigned with only 6 projects, then in the target sheet abc will get only 6 projects.

I am very new in Google Apps Script and I am unable to understand how can I do that.

Please assist!!