+ Reply to Thread
Results 1 to 5 of 5

Trying to create a dynamic table so I can create a updating drop down list.

  1. #1
    Registered User
    Join Date
    07-08-2019
    Location
    Nebraska
    MS-Off Ver
    16
    Posts
    8

    Trying to create a dynamic table so I can create a updating drop down list.

    Hello,
    I am trying to create a dynamic table so I can create an updating drop down list. I am importing data from another workbook which is an excel table. So I need to:

    1) create separate tables of data from that tables rows (A,B,C, and I)
    2) Sort all the date in ascending order
    3) delete any duplicate data

    I can create the tables but, don't know how to make it update to the last row of data and sort in ascending order. Hope that makes sense. Will this even work with a data list if it keeps updating? The drop down list will be on sheet 1 ("invoice"). I know the code needs to be changed but don't know what to.

    Thanks in advance!

    p.s. don't need them to be all different table styles, I was just messing around with that, Still learning VBA.

    Here's what I have so far...

    Please Login or Register  to view this content.

  2. #2
    Forum Guru Olly's Avatar
    Join Date
    09-10-2013
    Location
    Darlington, UK
    MS-Off Ver
    Excel 2016, 2019, 365
    Posts
    5,659

    Re: Trying to create a dynamic table so I can create a updating drop down list.

    Why not just use Power Query?
    let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source

    If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE

    Walking the tightrope between genius and eejit...

  3. #3
    Registered User
    Join Date
    07-08-2019
    Location
    Nebraska
    MS-Off Ver
    16
    Posts
    8

    Re: Trying to create a dynamic table so I can create a updating drop down list.

    Not downloaded on the comp. Using a work comp so cannot just download new software.

  4. #4
    Forum Guru Olly's Avatar
    Join Date
    09-10-2013
    Location
    Darlington, UK
    MS-Off Ver
    Excel 2016, 2019, 365
    Posts
    5,659

    Re: Trying to create a dynamic table so I can create a updating drop down list.

    Profile says 2016? Power Query included...

  5. #5
    Registered User
    Join Date
    07-08-2019
    Location
    Nebraska
    MS-Off Ver
    16
    Posts
    8

    Re: Trying to create a dynamic table so I can create a updating drop down list.

    I have it on my home computer. However, I think I was making this too hard for myself then realized I can just use the offset formula to create a dynamic list using the names manager. As for the sorting and duplicate issue this is what I came up with in case anyone needs a reference point.

    Probably not the most eloquent code but, it gets the job done!

    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1