Automatically Update Rows in Table

Hello,

I'm not sure if this is possible in Excel, but I thought someone here might know. I want to create an excel table/database and have the rows update based on changes to a list. For example...

Here is a list of employees:
Bob
Jim
Steve

Here is a list of projects:
Project1
Project2

And here's the relevant table I'd manually input the hours worked).

Project  | Employee | Hours Worked
Project1 | Bob      | 
Project1 | Jim      | 
Project1 | Steve    | 
Project2 | Bob      | 
Project2 | Jim      |
Project2 | Steve    |

What I'd want to do is make is so that if I changed the list of employees (say we just hired Susie) the table would automatically add two new rows... a "Project 1 | Susie" row and a "Project 2 | Susie" row. Is it possible to have the table automatically add the new rows in some way? This is a very simplified example, but the actual sheet I'm working with has dozens of employees and projects, so the automation is somewhat important.

I hope I'm making sense... if not, I'll try to clarify.

Thank you in advance for your time.

Komgol

You say this is a manually inputted worksheet at present?

I hope you don't mind me making the following observations; There are multiple employees, multiple projects and duplication on who works on what...?

Can I suggest you simply create;

Column A or Row A - Employees
Row A or Column A - Projects or names

What would determine which way around I would choose would depend on the higher variance of either projects or employees.

It strikes me that would be a lot simpler. If you then need further help get back to me and the data will be in a much more maneagable format.

I've attached a very simple example.

opsman
p.s. Apologies I didn't actually answer your question. Answer is probably yes using VBA and forms you could do it, but to keep things simple I would recommend my initial course of action first.