Nov 24 2021 05:03 AM
Hi!
I'm working with making an excel document so our office can plan our projects. It should have one sheet with a table where all projects are listed (let's call it AllProjects), and table each for the employees, where they can add how much they work on each project. The question for now is, how do I make it that whenever a new project is added to the AllProjects table, it shows up in all the other employee tables?
Kind regards
Kaj
Dell Precision 5560
Windows 10 Pro
Excel Version 2110 Build 16.0.14527.20270
Nov 25 2021 02:56 AM
Hi @Kaj_AL,
You can user dropdown list, but you need to use INDIRECT while referencing it into a data validation list.
If you still have a query pls attach sample file with your desired result entered manually.
Regards, Faraz Shaikh | Microsoft MVP, MCT, MIE, MOS Master, Excel Expert
If you find the above solution resolved your query don't forget mark as Official/Best Answer & like it to help the other members find it more.
Nov 25 2021 03:52 AM
Hi @Faraz Shaikh !
Thank you for your response! I'm not sure I followed your response, but maybe my question was not clear. I added an example file. In this file, I want to be able to add a row in the AllProjects table (maybe Project 11 to follow the naming in the file). Project 11 should then be added to all the employee tables automatically.
I hope I make sense.
Kind regards
Kaj