Hi All:
I have a running To Do list worksheet that I use at work. It is pretty straightforward with filters on column headings. I'd like to create tables from the worksheet, so that I could print the data and have a list for each job. Ideally, the table is real time and can simply be printed when needed. Right now, I filter and sort the data and print each project's to do items which takes a while.
Column Headers: Project Name | Description | Subcontractor | Responsible | Cost Impact | Created Date | Due Date | Closed
Should I create some sort of pivot table?
It would be great to group by project, sort by due date, then group by subcontractor.
Thanks in advance fr ideas.
I have a running To Do list worksheet that I use at work. It is pretty straightforward with filters on column headings. I'd like to create tables from the worksheet, so that I could print the data and have a list for each job. Ideally, the table is real time and can simply be printed when needed. Right now, I filter and sort the data and print each project's to do items which takes a while.
Column Headers: Project Name | Description | Subcontractor | Responsible | Cost Impact | Created Date | Due Date | Closed
Should I create some sort of pivot table?
It would be great to group by project, sort by due date, then group by subcontractor.
Thanks in advance fr ideas.