Using Drop Down Menu to present Selected data in same sheet

awaisdotcom · #1 01-22-2015, 12:34 AM

Greetings

I am working on Budget Presentation data for various departments. I have to create Drop Down menu of various departments i.e Click Cell 1, following Dept should appear Div1, Div2, Div3 and Div4.

Once user select Department, in the same sheet following data should appear:
1) HEAD 2)Div 3)FINAL_COMMIT 4)INITIAL_COMMIT 5)Complete 6) Incomplete

Data sheet is being uploaded herewith. I have tried alot but to no avail.

Any help would be much appreciated please.

Awais

charlesdh · #2 04-04-2015, 12:40 PM

Sorry no one on this forum picked up on this.
User may have a possible answer at
http://www.excelforum.com/excel-char...ame-sheet.html

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Need help with drop-down menu please	cazclocker	Excel	7	01-05-2015 04:07 PM
Methods to pull data from another sheet using drop down list	fajl	Excel	0	07-19-2014 12:31 AM
HELP -- Drop Menu for Reoccuring Data??	cscaudle	Word	1	03-02-2014 10:19 AM
Drop down menu with different value to display name	swsquish	Word	1	09-04-2012 08:45 PM
How to get the Name of the selected menu	anil3b2	Word	0	07-26-2010 02:44 AM