To Do List > Table

Hydestone

Board Regular
Joined
Mar 29, 2010
Messages
124
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.
 

Some videos you may like

Excel Facts

Can a formula spear through sheets?
Use =SUM(January:December!E7) to sum E7 on all of the sheets from January through December

RasGhul

Well-known Member
Joined
Jul 15, 2016
Messages
609
You could use array formula to extract your to do list for a particular job #.

Can you post some sample data?
 

Watch MrExcel Video

Forum statistics

Threads
1,108,984
Messages
5,526,060
Members
409,682
Latest member
HisHailo

This Week's Hot Topics

Top