[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 198
  • Last Modified:

Drop down list

Hi Experts;

Please find attached Excel Sheet. I want to create a drop down list contains team a or b If I selct the team all data for that team will appeare. and so if I select another team.
smart-menu-example.xlsx
0
obad62
Asked:
obad62
  • 4
  • 3
1 Solution
 
ukerandiCommented:
go to Data Menue
->select filters-> and auto filter
0
 
ukerandiCommented:
see attached example



smart-menu-example.xlsx
0
 
obad62Author Commented:
Hi ukerandi,

I know filter function job. pls find attached example am looking to creat same.
am looking to creat a menu or a drop down list.
Mutli-year-calender.xlsx
0
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
Saqib Husain, SyedEngineerCommented:
I am not sure what you are trying to do but for your original question here is a solution using the worksheet_change and the worksheet_selectionchange events and data validation.

Copy-of-smart-menu-example.xlsm
0
 
obad62Author Commented:
Sir,

very sorry for my late response;
as mechanism it is what I want, but as reslut it is not showing the same table in sheet1 as is.

I do appreciate your help.
0
 
obad62Author Commented:
I've requested that this question be deleted for the following reason:

no proper answer
0
 
ukerandiCommented:
wait i will put proper answer
0
 
ukerandiCommented:
this is working Perfectly check the my attachement
before select drop down box youhave to enebaled Macro

Data comming from Sheet2, you can change the Yes and No data find the differce
Copy-of-smart-menu-example.xlsm
0

Featured Post

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now