Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Need help to update a column when Drop Down List is changed
Hi: I have created a workbook with one tab consisting off all data that needs to be accessed by management. The second tab consists of a summary of this data with a drop down list so only one department can be pulled at a time with vlookup formulas pulling the data from the first tab. I have however added a Commentary column on my second tab that I need to also be dynamic and change when the drop down list is changed so commentary can be added to each department selected. Numerous people will access this file and add their own notes. How can I accomplish this?
Thanks tanya ADDITION: I have added an example of my spreadsheet to assist you in hopefully helping me. I am desparate for help! Thank you!!!! Last edited by tanyag2 : February 12th 13 at 04:44 PM Reason: add attachment |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to Update drop-down list? | Excel Discussion (Misc queries) | |||
IF function and Drop down list UPDATE | Excel Programming | |||
Update to List-Comparison Macro to Show What Data Has Changed? | Excel Programming | |||
Drop down list Update | Excel Discussion (Misc queries) | |||
Text to Columns from drop down list update | Excel Discussion (Misc queries) |