Transferring Data from One Worksheet to Another

[wtopping]

Hi All,

I have a workbook, which holds two Team planners. Either the individual is in work (marked with an x) or on leave (marked with an L),

On a Monday morning we have a weekly meeting which is documented for historical reasons. At the moment we have another work book which must be updated manually by the boss using the planners as a reference.

What i would like to achieve is when an individual puts an X on a Monday it automatically fills out the Monday attendance list with there details.

What i would also like to do is once Monday has passed it automatically updates the date for the following Monday morning meeting.

I have uploaded a rough copy of the work book, to i hope make it easier to understand,

Thanks for any help, greatly appreciated

Combined Planners.xlsx

[flesem25]

Combined%20Planners(1).xlsx

So all i could think of was to input all the employees on the monday morning meeting and then add a column to do an hlookup based on their group, this can be sort of intensive. Then set up an auto filter on that new column. And then you could set the print area to not inclued that column. The only down side is that you have to reset the filter everytime you change the date. see attached