Excel Guides

Tasks for each workbook in Excel

There are a few different ways to approach this. If you want to get really detailed, you can create a separate worksheet for each task and then use the VLOOKUP function to populate the cells in the workbook with the appropriate information. However, if you're just looking for a quick and easy way to keep track of tasks, you can simply create a list in one of the worksheets and then use conditional formatting to highlight the cells that correspond to the task at hand.

Assuming you want to go the route of creating a separate worksheet for each task, here's what you need to do:

  1. Create a new worksheet for each task.
  2. In each worksheet, create a table with columns for the task name, description, due date, and status.
  3. Populate the cells in the table with the appropriate information.
  4. In the workbook that will contain your list of tasks, create a table with columns for the task name, description, due date, and status.
  5. In the first cell of each column, enter a formula that will lookup the corresponding information in the other worksheets. For example, in the first cell of the "Task Name" column, you would enter =VLOOKUP(A1,'Task 1'!A1:D1,1,FALSE).
  6. Copy and paste this formula down the column until all of the tasks are listed.

Once you have all of your tasks listed in one place, you can use conditional formatting to highlight cells based on their content. For example, you could use a rule that highlights all cells in the "Due Date" column that are within 7 days of today's date. This would give you a quick way to see which tasks are coming due soon.

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.