MODERATOR NOTICE: This topic has also been posted on other sites and may already have an answer elsewhere. Please take this into consideration when answering this question
crossposted: https://chandoo.org/forum/thre…ion-of-sorted-data.49926/
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 pics, I would like to select only orange columns
