Forum Discussion
Solved
VBA Format data as table and filter
Hello! I'm writing a macro to make a data output look nicer for users. I have formatted the data as a table, and now I want to sort the data on two things: first Supplier Name, then Product Descr...
Does this work for you?
tbl.Range.Sort key1:=Range("C1"), order1:=xlAscending, key2:=Range("D1"), order2:=xlAscending, Header:=xlYes
Does this work for you?
tbl.Range.Sort key1:=Range("C1"), order1:=xlAscending, key2:=Range("D1"), order2:=xlAscending, Header:=xlYes
- Yes this works perfectly, thanks so much for your help!
You're welcome Rachel1994! Glad it worked as desired.
