Can I insert a row in two separate tables?

mstgier

New Member
Joined
May 28, 2020
Messages
4
Office Version
365
Platform
Windows
Dear Community,
I thought I was clever to setup and create a List for my Team, where we can share and enter our Day-Off Time.
Therefore, I generated a Table with all the members and created for each month a separate Sheet, where within the sheet I have a second Table that is showing the days.
What I did not consider is, that with new members coming and some leaving, I am able to update the Table with the Agents but I have an issue with the data entered in the cells of the month.

As you can see in the below image on the left side, the current situation. In my Sheet with the Agents, I have 5 names with examples.
In the second sheet, I added the Month June and have the days accordingly. We did color the cells to announce, that we are not around. So in the below example, Edward won't be around
on June 5th.

Now a new Agent is added to the Table with Agents called Diane as seen on the right side in Row A7.
The nice thing is, that Diane is showing up also in the Month Sheet June but as you can see, the Cell F7
which I hoped would move to Cell F8 hasn't moved and therefore, the information now is no longer correct,
because Edward has no longer the day off, while Diane has. I also tried with numbers and it also does not work.

Is there some trick, how I can do that or build the Vacation form in a different way?

Thank you very much,
Mike

Insert Row in two differnt tables.JPG
 

Some videos you may like

Excel Facts

Links? Where??
If Excel says you have links but you can't find them, go to Formulas, Name Manager. Look for old links to dead workbooks & delete.

mstgier

New Member
Joined
May 28, 2020
Messages
4
Office Version
365
Platform
Windows
OH sorry, I forgotten to mention, that I tried to add a new row with both Sheets activated and also to add a new row in the table itself, on both ways, "Insert" was grayed out and I couldn't choose from.
 

Watch MrExcel Video

Forum statistics

Threads
1,098,863
Messages
5,465,120
Members
406,414
Latest member
Discorz

This Week's Hot Topics

Top