TomNR
Member
Hi all,
I hope someone can help me on this one as I am pretty stumped on!
So I have created the basic foundations of what I am after.
The worksheet called 'Multi-skilled' will be changed each week, adding the relevant rosters for that particular week.
Then I will have 45 or so separate worksheets unique to each member of the team.
Basically I am looking for a way to push the date specific data entered into the 'Multi-skilled' worksheet out into the respective employee specific worksheets and into the correct rows which are spaced out by the 'Week Ending' date, which can be found on the 'Multi-skilled' worksheet in K2 and the staff worksheets in Column N.
I have attached what I have built so far and am open to any suggestions on moving the data around the Workbook.
Thank you all in advance!
I hope someone can help me on this one as I am pretty stumped on!
So I have created the basic foundations of what I am after.
The worksheet called 'Multi-skilled' will be changed each week, adding the relevant rosters for that particular week.
Then I will have 45 or so separate worksheets unique to each member of the team.
Basically I am looking for a way to push the date specific data entered into the 'Multi-skilled' worksheet out into the respective employee specific worksheets and into the correct rows which are spaced out by the 'Week Ending' date, which can be found on the 'Multi-skilled' worksheet in K2 and the staff worksheets in Column N.
I have attached what I have built so far and am open to any suggestions on moving the data around the Workbook.
Thank you all in advance!