# Auto filter data According Particular Column base ?????

[krunal123]

( i was try to making Auto filter data) "When I paste data into a table, the data should be sorted by invoice number, pleased Share to right way vba to possible Tricks"

 

[Joe4]

You cannot copy, paste, and sort data all in one step.
Simply sort the data after you paste it into your table.
You can get most of that sorting code simply by turning on your Macro Recorder and recording yourself sorting the data manually.
Then stop the Macro Recorder and view your code, and it should give you most of the code you need.