B
Brian
on sheet represents one employee and the days he works and his productivity.
the dates of work are in column A row 1 down to 16 or 17 or so, and in
column B row 1 is the month that the productivity took place. On sheet two
lists all the months for several years with the dates listed under the month.
For example January-06 is in A1 and under that from A2 down to A16 or A17 or
so, list the date in each cell for example A2 is 1, A3 is ,2 etc. and B1 is
February-06 with its dates listed in B2 down to B16 or B17 or so. Let's go
back to sheet one and what I want to do is if the month in col B row 1 is
let's say January-06 then I want the respectives dates listed under
January-06 on sheet two to be placed in col A1 down to A16 or 17 or so
(depending on how many workdays an employee is scheduled that month) is
something like this possible and if so how?
Employees work four days on and then four days off, so it becomes hard each
time I start a new sheet for a month for me to go down column A and manually
type in their first day of work in a month which might be the 3rd for example
and then count 4,5,6 11,12,13,14, 19,20,21,22, 27,28,29,30. So I did it
once on sheet two for 3 years worth of scheduling and I am looking to now
have each set of days in a work month exported to each employees sheet in
Column A rows 1 down to 16 or 17.
Thank You,
brian
the dates of work are in column A row 1 down to 16 or 17 or so, and in
column B row 1 is the month that the productivity took place. On sheet two
lists all the months for several years with the dates listed under the month.
For example January-06 is in A1 and under that from A2 down to A16 or A17 or
so, list the date in each cell for example A2 is 1, A3 is ,2 etc. and B1 is
February-06 with its dates listed in B2 down to B16 or B17 or so. Let's go
back to sheet one and what I want to do is if the month in col B row 1 is
let's say January-06 then I want the respectives dates listed under
January-06 on sheet two to be placed in col A1 down to A16 or 17 or so
(depending on how many workdays an employee is scheduled that month) is
something like this possible and if so how?
Employees work four days on and then four days off, so it becomes hard each
time I start a new sheet for a month for me to go down column A and manually
type in their first day of work in a month which might be the 3rd for example
and then count 4,5,6 11,12,13,14, 19,20,21,22, 27,28,29,30. So I did it
once on sheet two for 3 years worth of scheduling and I am looking to now
have each set of days in a work month exported to each employees sheet in
Column A rows 1 down to 16 or 17.
Thank You,
brian