• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Need VBA file for automatic selection of sorted data

sagar2295

New Member
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
 

Attachments

  • 1.png
    1.png
    35.4 KB · Views: 5
  • 2.png
    2.png
    19.2 KB · Views: 6
  • 3.png
    3.png
    23.8 KB · Views: 5
  • 4.png
    4.png
    6.5 KB · Views: 4
sagar2295
Please, reread Forum Rules
There are clear sentences about Cross-posting.
 
Back
Top