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.

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

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.