Combining dynamic dependant drop down lists in a single result

nandomclaren

New Member
Joined
Jan 10, 2014
Messages
1
Hi,


I'm not an expert in Excel, but I need to make a sheet to facilitate my work. I will describe the situation, so you guys maybe will see a different solution for my problem. I have a spreadsheet where I have different inputs, and new arriving every week (let's call it #Input1). I have a different spreadsheet where I made a simple formula for the inputs in #Input1 arrive and fill a column with their info (this spreadsheet is #Input2). Here, the tasks that arrive via #Input1 all have a drop down list, with the options: Concluded, Work in Progress, Not Iniciated. I need to be able to transfer this info to #Input3, which is the final spreadsheet.


There are several #Input2 spreadsheets, one for each project we work on. And all of them go to #Input3, where I combine all the info from them in a single table. So, I have two problems to solve:


1) How to send the right info to #Input3, since it's a drop down list? What I need is that, when the user selects an option in #Input2, for instance, Work in Progress, the same task appears in #Input1 and #Input3 as Work in Progress (all of them have the column Status).


2) To complicate things, not all of the info goes to #Input3, but they go combined. I explain: in #Input2, there are tasks but also subtasks. In #Input3, there are only subtasks. So, sometimes there is a task in #Input3 that can only be marked as Concluded when tasks 10,11 and 17 in #Input2 are marked as Concluded. How can I transfer this correctly to #Input3?


Help, please?
 

Excel Facts

What is =ROMAN(40) in Excel?
The Roman numeral for 40 is XL. Bill "MrExcel" Jelen's 40th book was called MrExcel XL.

Forum statistics

Threads
1,218,620
Messages
6,143,523
Members
450,492
Latest member
Rusbus1972

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top