Forum Discussion
Solved
Create Sheet that Populates Rows from Multiple Drop Down menus
I have a spreadsheet with five sheets that list projects and whether they are complete or in progress. Each sheet has a list of projects that each have a drop down menu with complete or in progress...
PortCraneTech You wrote "I have a spreadsheet with five sheets that list projects", but you did not mention the names of those five sheets. So I used WkshtAble, WkshtBaker, WkshtCharlie, WkshtDelta, and WkshtEcho as placeholders. Replace those names with the names of your five sheets (and change the "none for" literals accordingly, to something meaningful to you). Note that if your worksheet names include spaces or other special characters, you will have to wrap those names inside apostrophes (e.g., 'Project Sheet 1').
Similarly, change the ranges to be specific to your problem. I hypothesized that columns A thru ZZ were used; change those column references as appropriate. I hypothesized that your column D contained the status; change those column references as appropriate.
SnowMan55 I have done what you suggested but am having problems. When I paste in your formula to cell A3, I get a pop up window 'Update Values:WkshtAble' with the option to open something. I don't know what to do with this? If I just cancel it out, A3 turns to '#REF!'.
What am I missing?
Thanks for your help
PortCraneTech You wrote "I have a spreadsheet with five sheets that list projects", but you did not mention the names of those five sheets. So I used WkshtAble, WkshtBaker, WkshtCharlie, WkshtDelta, and WkshtEcho as placeholders. Replace those names with the names of your five sheets (and change the "none for" literals accordingly, to something meaningful to you). Note that if your worksheet names include spaces or other special characters, you will have to wrap those names inside apostrophes (e.g., 'Project Sheet 1').
Similarly, change the ranges to be specific to your problem. I hypothesized that columns A thru ZZ were used; change those column references as appropriate. I hypothesized that your column D contained the status; change those column references as appropriate.
- Hey it worked. Thanks so much for your help.