I have a vbsctipt that opens an Excel(2007) document copies the used range from two sheets (minus the header on sheet 2) puts it all on 3rd sheet. I then need to sort that data using the header. I have the values of the range I need to sort in a vairable already. I just don't know the sytax to get Excel to sort it based on the data in Column A.
Modified 12 years, 4 months ago
Viewed 11k times
Add a comment |
See if this is what you're looking for.