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...