• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 257
  • Last Modified:

Drop down list Macro help

Hi Experts,

Please find attached eaxmple excel file of what am trying to end up with.
The issue is that I want when I select the team A or B It brings all data belongs with same foramt and coloring. In addition I want to add one item ( All ) if I select it calls all teams.

Thank you.
example--smart-menu-example.xlsx
0
obad62
Asked:
obad62
  • 2
1 Solution
 
gowflowCommented:
Sorry a quick way that need to be finetuned check sheet2 and select in C3 from the dropdown the value that you want. Will need to add All and make them start on first row.
gowflow
example--smart-menu-example.xlsx
0
 
obad62Author Commented:
Hi Goflow, you did a great job. apartially, to solve Team B issue (it shows down )
am thinking to put each team data in a sheet as I attached.
Help me to make shown in same place like Team A.

Plus I need to add one item in this list ( All ) it can call all teams.

manmy thanks.
try.xlsx
0
 
gowflowCommented:
This is what you want ? Sheet2 is ok trying to work on All in Sheet2 All but still not easy are now you have broken sheets when tey were all in the same sheet it was easier for All will get there. Check sheet2
gowflow
try.xlsx
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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