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,

Name	Days Willing to work	Start date	Finish Date
John Smith	Monday, Wednesday	20/06/16	31/12/16

<tbody>
</tbody>

Days Working

Name	Day	Date
John Smith	Monday	20/06/16
John Smith	Wednesday	22/06/16
John Smith	Monday	27/06/16
John Smith	Wednesday	29/06/16

<tbody>
</tbody>

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

thanks in advance

 

[ardykav]

Any takers on the above?