Autocompleting a Sheet based on one row of information

[ardykav]

Hi All,

I have a tab (scheduled days to work) where I put in a persons name and what days of the week they say they want to work. What i want to do is once the data is put in like the first table below a button is pressed and it will automatically populate a whole new tab for the times they have said they will work, table 2 being the result. I am thinking its some kind of Do until function but not entirely sure,

[TABLE="width: 500"]
<tbody>[TR]
[TD]Name[/TD]
[TD]Days Willing to work[/TD]
[TD]Start date[/TD]
[TD]Finish Date[/TD]
[/TR]
[TR]
[TD]John Smith[/TD]
[TD]Monday, Wednesday[/TD]
[TD]20/06/16[/TD]
[TD]31/12/16[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


Days Working
[TABLE="width: 500"]
<tbody>[TR]
[TD]Name[/TD]
[TD]Day[/TD]
[TD]Date[/TD]
[/TR]
[TR]
[TD]John Smith[/TD]
[TD]Monday[/TD]
[TD]20/06/16[/TD]
[/TR]
[TR]
[TD]John Smith[/TD]
[TD]Wednesday[/TD]
[TD]22/06/16[/TD]
[/TR]
[TR]
[TD]John Smith[/TD]
[TD]Monday[/TD]
[TD]27/06/16[/TD]
[/TR]
[TR]
[TD]John Smith[/TD]
[TD]Wednesday[/TD]
[TD]29/06/16[/TD]
[/TR]
</tbody>[/TABLE]

These rows would repeat for this person until 31/12/16

thanks in advance

 

[ardykav]

Any takers on the above?