Need help to update a column when Drop Down List is changed

T

tanyag2

Hi: I have created a workbook with one tab consisting off all data tha
needs to be accessed by management. The second tab consists of
summary of this data with a drop down list so only one department can b
pulled at a time with vlookup formulas pulling the data from the firs
tab. I have however added a Commentary column on my second tab that
need to also be dynamic and change when the drop down list is changed s
commentary can be added to each department selected. Numerous peopl
will access this file and add their own notes. How can I accomplis
this?

Thanks
tany
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formatted cell column in drop down list 1
dependent drop down list 1
Filtered drop down list 2
Drop Down Lists 2007 10
How do I create a drop down box within a drop down box? 1
Advanced Drop Down List Option 0
Drop down list Update 2
can I autopopulate from a long drop down list in Excel? 2

Top