Multiple linked tables that can all be edited, and automatically update across all?

VikingLink

New Member
Joined
Jun 18, 2022
Messages
25
Office Version
  1. 365
Platform
  1. Windows
I'd like to be able to create a to do list for our front desk, where the manager can create a to do list, and each employee can filter it to see only what they have to do.
When finishing a chore, they can tick it off, and that will then show in all tables. Should they need to pass a task on to another employee, they can also change that name. Deleting a row in a table would also be something they often do. All the tables should always automatically update if there is a change in either one of them.

I would put these tables on different sheets, but in the example below, I added them to the same one, just to make it visible.
At the top left you see the manager's table, so he/she has an overview of the entire day,the ones below are for two of the employees that they can filter.

To make it more complicated, I would need a master table for Monday, Tuesday, Wednesday, Thursday and Friday, and one for urgent tasks not linked to a specific day. All of these would be on separate sheets. These tables are displayed in my example starting at column G.

Each employee would have a sheet with their own name, and on those sheets the table would automatically display the data of the current day combined with the data of the urgent tasks.

Is this doable?

Book1
ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAE
1
2WednesdayMondayTuesdayWednesdayThursdayFridayUrgent
3FinishedTaskResponsibleFinishedTaskResponsibleFinishedTaskResponsibleFinishedTaskResponsibleFinishedTaskResponsibleFinishedTaskResponsibleFinishedTaskResponsible
4xtask 1Jolenetask aEddytask aEddyxtask 1Jolenetask aEddytask aJolenetask aJolene
5task 2Eddytask bEddytask bEddytask 2Eddytask bEddytask bJolenetask bEddy
6task 3Jolenetask cJolenetask 3Jolenetask cEddytask cJolenetask cJolene
7task aJolene
8task bEddy
9task cJolene
10
11FinishedTaskResponsible
12xtask 1Jolene
14task 3Jolene
15task aJolene
16task cJolene
17
18
19FinishedTaskResponsible
21task 2Eddy
23task bEddy
24
25
26
27
OriginalTable
Cells with Conditional Formatting
CellConditionCell FormatStop If True
O4:Q6Expression=$B4="x"textNO
B20:D23Expression=$B4="x"textNO
B12:D16Expression=$B4="x"textNO
B4:D9Expression=$B4="x"textNO
 

Excel Facts

How to total the visible cells?
From the first blank cell below a filtered data set, press Alt+=. Instead of SUM, you will get SUBTOTAL(9,)

Forum statistics

Threads
1,223,227
Messages
6,170,848
Members
452,361
Latest member
d3ad3y3

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top