Thread: Using Drop Down Menu to present Selected data in same sheet
View Single Post
 
Old 01-22-2015, 12:34 AM
awaisdotcom awaisdotcom is offline Windows 7 64bit Office 2013
Novice
  
Join Date: Jan 2015
Posts: 1
awaisdotcom is on a distinguished road
Default Using Drop Down Menu to present Selected data in same sheet
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
Attached Files
File Type: xlsx Test.xlsx (22.6 KB, 10 views)
Reply With Quote