Forms using Data
Results 1 to 3 of 3

Thread: Forms using Data
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular
    Join Date
    Jul 2007
    Posts
    72
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Forms using Data

    All -

    I currently have a drop of data with 3000 rows and 26 columns of data that I need I need to filter based off a certain city within the data

    Would like to create a summary form with the cities and when I click on the certain city it would then show me all the info for the pertain rows and columns.

    What kind of Macro would be needed for this?

  2. #2
    Board Regular sykes's Avatar
    Join Date
    May 2002
    Location
    Cornwall,England
    Posts
    1,560
    Post Thanks / Like
    Mentioned
    4 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Forms using Data

    Quote Originally Posted by volsfan210000 View Post
    All -

    I currently have a drop of data with 3000 rows and 26 columns of data that I need I need to filter based off a certain city within the data

    Would like to create a summary form with the cities and when I click on the certain city it would then show me all the info for the pertain rows and columns.

    What kind of Macro would be needed for this?
    Can't you do just that - and select your whole table of data, then use "Data"/"Filter" then, using the dropdown on your "City" column, only select the name of the city you want the data for?
    Sykes
    Windows 10 / XL 2016
    Members don't have crystal balls, so PLEASE describe your situation, code,
    and requirements ACCURATELY in your first post. It saves hair!
    Better still - upload your spreadsheet (and formulae!) with this great bit of kit.


    - forum use guidelines, forum rules and terms of use
    - Try searching for your answer first, see how
    - Read the FAQs
    - List of BB codes

  3. #3
    MrExcel MVP
    Moderator
    Fluff's Avatar
    Join Date
    Jun 2014
    Location
    Chippenham
    Posts
    25,664
    Post Thanks / Like
    Mentioned
    445 Post(s)
    Tagged
    45 Thread(s)

    Default Re: Forms using Data

    You can also use Excel's built in "Filter on Selection" feature.
    To set it up, right click on the ribbon > Customize ribbon > in "Choose commands from " select Commands not in the ribbon > Select "Autofilter" (it's misnamed) > click on "New Group" > Add
    - Posting Data try one of these tools
    - Posting guidelines, forum rules and terms of use
    - Read the FAQs

    Running Office 365 on Win 10

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •