Hi,
On several worksheets I've got a list of names in one column, A. These are the same names in each worksheet.
Columns B to O are the dates of the week.
For each person's name on each row, I have listed where they are at and what they are doing, much like a timesheet.
I'd like to create a report using this data, but broken down by week.
The entries for each person are simple and repeating, like "sick", "office", "traveling". I'd like the report to give me a simple view of the data, like:
Joe: 16-19 June; traveling. 20 June, office.
Sam: 16-20 June; traveling.
Ed: 16-20 June; sick
Bill: 16-18 June; office. 19-20 June; traveling.
It would also ben ice to export this into a MS Word doc too..
How could I even start something like this?
Thanks for all the help. This community is great and I'm learning so much from all of your tips.
Thanks!!
tim
On several worksheets I've got a list of names in one column, A. These are the same names in each worksheet.
Columns B to O are the dates of the week.
For each person's name on each row, I have listed where they are at and what they are doing, much like a timesheet.
I'd like to create a report using this data, but broken down by week.
The entries for each person are simple and repeating, like "sick", "office", "traveling". I'd like the report to give me a simple view of the data, like:
Joe: 16-19 June; traveling. 20 June, office.
Sam: 16-20 June; traveling.
Ed: 16-20 June; sick
Bill: 16-18 June; office. 19-20 June; traveling.
It would also ben ice to export this into a MS Word doc too..
How could I even start something like this?
Thanks for all the help. This community is great and I'm learning so much from all of your tips.
Thanks!!
tim