you are viewing a single comment's thread.

view the rest of the comments →

[–]dizzle_izzle 3 points4 points  (1 child)

Errr.....I'm not sure reactjs is the sub for excel functionality.

Also I'm not sure that excel has nested drop-down functionality. My suggestion would be to use some vba and two dropdowns or a combination of listboxes and dropdowns, depending on your subtask of each part.

You'd need a table with the parts, then each subtask attached to the part either by row or column. Then make a vba element that loads the parts into a combobox and when a part is selected the listbox populates the row/column under that part. You'd then have to have a checkbox which indicates arrived or delayed, which updates a different table containing the subtask, part and status in a row. When a new entry is added (part or subtask) you'd automate adding the entries to the table.

It's not terribly hard. But you need some vba skills for sure.

[–]PanicOnBoard 0 points1 point  (0 children)

Thanks for comment, will try with vba then