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).

Please Login or Register  to view this content.

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.