Need VBA file for automatic selection of sorted data

[sagar22951]

I would like to create a macro for automatic selection of the filtered data. Please help me with VBA code.
The steps for selecting the data:
1) I sorted raw data
2) From that filtered data, I am selecting only 3 columns (Column 1st, 3rd, 5th)
3) Selecting 3 columns for making a copy-paste
After performing any filtering/sorting, I need to select the data from the specific three columns.
Please see below pic, I need to select only orange

 

[kevin9999]

This is easily achievable using Advanced Filter, but you'll need to provide more information if you want a VBA solution. What is your exact filter criteria for Sales? Day seems to be Fri or Sat or Sun? Where do you want the filtered records copied to - same sheet, another sheet, what cell address do you want them to go to? What are the sheet names?

You might also consider using the XL2BB add in to provide a sample of data that volunteers could use - very few would be willing to manually type out your table to test any code...

 

[Fluff]

Welcome to the MrExcel Message Board!

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: Need VBA file for automatic selection of sorted data
and Need VBA file for automatic selection of sorted data - OzGrid Free Excel/VBA Help Forum
If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.