Dynamic Table based on Dropdown Value

[chickyguy]

Hi folks,

So I'm trying to create a template that can be used as a guide for newcomers to the team.

The dropdown list contains values that the person will select, and I want the table of steps to be populated below based on this dropdown value.

To be exact:
Scenario 1:

Select:

Process A

S/N	Step	Status	Action Personnel
1	Do Foo	New
2	Do Bar	New

...

Scenario 2:

Select:

Process B

S/N	Step	Status	Action Personnel
1	Do Baz	New
2	Do Qux	New

...

Now I know excel isn't exactly the right tool for this job, but I was able to get it somewhat working with this method.

However, it's very clunky and will be hard to add additional steps, which is why I was seeking a different method that reads off a table in a hidden tab and retrieve that instead, based off this page.

The problem is, the spillover table I'm referencing as =D1# now becomes the following:

S/N	Step	Status	Action Personnel
1	Do Baz	New	0
2	Do Qux	New	0

The font is different, and I can't actually make any changes to the table, for example changing "New" to "Completed".

Is there an alternative solution, or is VBA the only answer?

 

[coulombevin]

Hi Chickyguy,

Sorry for the delay. Before we go further, does the excel contain only a cell with select and a table with SN (?), Step Status and Action Personnel. Also, if it is easier for you to explain in french, you can do so (base on action personnel).

Based on what i understant, which look like a dashboard which register where you are in your formation but with multiple 'page' whitout using multiple sheets, I would probably go with VBA which we could look into.

Bests regards,

Vincent